Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello,
My objected is two parts (1) Calculate a dynamic ranking for a basic matrix (2) Create individual measures that return the name and profit for a specific rank (e.g. rank 2).
(1) Created Dynamic ranking calculated measure with following equation:
As you can see, it worked. And as I change the filters on the page, it dynamically adjusts.
@Anonymous , refer
, refer my rank
City Rank = RANKX(all(Geography[City]),[Sales])
filters I tried
Rank Top 10= CALCULATE(if([City Rank]<=10,[Sales],BLANK()) ,VALUES(Geography[City]))
Rank Top 10 1 = sumx(VALUES(Geography[City]),if([City Rank]<=10,[Sales],BLANK()) )
Top 10 City Rank = CALCULATE([Sales],TOPN(10,all(Geography[City]),[Sales],DESC),VALUES(Geography[City Id]))
Rank 2nd top = sumx(filter(VALUES(Geography[City]),[City Rank]=2),[Sales] )
https://databear.com/power-bi-dax-topn-function/
User | Count |
---|---|
42 | |
28 | |
23 | |
18 | |
15 |
User | Count |
---|---|
54 | |
35 | |
18 | |
17 | |
15 |