Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Solved! Go to Solution.
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
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
User | Count |
---|---|
128 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |