0 votes
1 view
in BI by (10k 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 (20.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 Dec 22, 2020 in BI by Chris (10k points)
0 votes
1 answer
asked Nov 24, 2020 in BI by Chris (10k points)
0 votes
1 answer
asked 1 day ago in BI by Chris (10k points)
0 votes
1 answer
0 votes
1 answer
Welcome to Intellipaat Community. Get your technical queries answered by top developers !


Categories

...