Intellipaat Back

Explore Courses Blog Tutorials Interview Questions
0 votes
2 views
in BI by (11.1k points)

I am using a dataset 

raw data set

and I am using a measure for sum of mark column

DAX_mark_sum=sum(mark)

and I have got the following result

result

I need top 2 records and how can I do this?

1 Answer

0 votes
by (22.5k points)
edited by

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!

Related questions

0 votes
1 answer
asked Apr 6, 2021 in BI by Chris (11.1k points)
0 votes
1 answer
asked Dec 22, 2020 in BI by Chris (11.1k points)
0 votes
1 answer
asked Nov 24, 2020 in BI by Chris (11.1k points)
0 votes
1 answer
0 votes
1 answer
asked Mar 4, 2021 in BI by Chris (11.1k points)

31k questions

32.8k answers

501 comments

693 users

Browse Categories

...