Solved: Using power bi how to show top 10 records accordin...

Shweta · ‎03-15-2016

coollehavre · ‎03-18-2016

Hi,

to display the top 10 (by country for example), you can create a new calculated column in a data table like :

Rank Sales = RANKX(ALLSELECTED(Data1[Country]);CALCULATE(SUM(Data1[Sales])))

And you filter by the column

coollehavre · ‎03-18-2016

Hi,

to display the top 10 (by country for example), you can create a new calculated column in a data table like :

Rank Sales = RANKX(ALLSELECTED(Data1[Country]);CALCULATE(SUM(Data1[Sales])))

And you filter by the column

Using power bi how to show top 10 records according to check-in timming