Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi,
I have two measures:
Total Revenue = Sum(DSS[Revenue])
RankDebtors = RANKX(All(DSS[Debtors]),[Total Revenue])
Now, I need another measure which gives me the Total Revenue for Top 10 Debtors. I have tried few formulas including this:
RevenueTop10Debtors = CALCULATE(SUM(DSS[Revenue]), FILTER(DSS,[RankDebtors]<=10)).
But, I couldn't get it to work. What should the measure be written?
Solved! Go to Solution.
@bjoshi How about this?
RevenueTop10Debtors = CALCULATE ( [Total Revenue], TOPN ( 10, ALL ( DSS[Debtors] ), [RankDebtors], ASC ) )
HTH!
BTW try this also you were almost there...
RevenueTop10Debtors = CALCULATE ( [Total Revenue], FILTER ( ALL ( DSS[Debtors] ), [RankDebtors] <= 10 ) )
Both these Measures should give you the same result!
@bjoshi How about this?
RevenueTop10Debtors = CALCULATE ( [Total Revenue], TOPN ( 10, ALL ( DSS[Debtors] ), [RankDebtors], ASC ) )
HTH!
BTW try this also you were almost there...
RevenueTop10Debtors = CALCULATE ( [Total Revenue], FILTER ( ALL ( DSS[Debtors] ), [RankDebtors] <= 10 ) )
Both these Measures should give you the same result!
User | Count |
---|---|
80 | |
76 | |
70 | |
69 | |
54 |
User | Count |
---|---|
104 | |
99 | |
92 | |
78 | |
69 |