Back
I am using a dataset
and I am using a measure for sum of mark column
DAX_mark_sum=sum(mark)
and I have got the following result
I need top 2 records and how can I do this?
Use the following measure:
Top 2 Emp Id :=CALCULATE ( TOPN ( 2, VALUES ( 'Table'[Emp_Id] ), [DAX_mark_sum] + RAND () ) )
Check out the Power BI tutorial for more reference
Get an introduction to Power Bi from the below video:
Be a certified Power BI professional by going for Intellipaat’s Power BI Certification!
31k questions
32.8k answers
501 comments
693 users