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)

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: 

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)
Welcome to Intellipaat Community. Get your technical queries answered by top developers!

28.5k questions

29.9k answers

500 comments

99.1k users

Browse Categories

...