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 a matrix where I want to return the rank of my customer by total sales for a specific period.
I put this DAX
Solved! Go to Solution.
Hi @vbourbeau ,
Maybe you could refer to below link about rank with hierarchy:
https://dataninjago.com/2017/12/11/dax-ranking-with-hierarchy-drill-down/
Regards,
Daniel He
Hi,
With my true data when I apply the filter the matrix give me this error:
there's not enough memory to complete this operation
I restart my computer and nothing.
Without the filter the matrix run in a sec.
Look If I add a line in my matrix the rank lost is mind? See the pbix
link to te file https://we.tl/t-0gcXo9Adwq
I want to rank the client, as we see in my example.pbix
Thank you
Do you know if it's my dax the problem, because if the date are in the same table as the invoice the problem don't occure? kind of relationship with both table?
Maybe you can filter the blank in Filters Pane where mTotal Sales is not blank.
Hi @vbourbeau ,
Could you please post some simple sample data and your desired result to have a test if possible? Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
Regards,
Daniel He
I realize that my date measure are on another table that InvcDtl. It's the reason why the rank took all my customer. But my date table are linked with my InvcDtl table? Why the Date filter won't apply?
Ok I do a example see the attachment.
the result give that
ClienD and ClientE don't have any sales in 2016 but the table show them?
If I remove my Rank measure the filter work ok.
I don't know how to add my pbix so I create a link. https://we.tl/t-f0OQ4nhFOm
Hi @vbourbeau ,
Based on my test, you could refer to below formula:
Rank = IF(CALCULATE(SUM(Line[amount]))=BLANK(),BLANK(),rankx(ALLSELECTED(Line[Client]),CALCULATE(SUM(Line[amount]))))
Result:
Regards,
Daniel He
Stil there,
Can you send me your modify pbix
Hi @vbourbeau ,
You could view the PBIX in my attachment.
Regards,
Daniel He
OK but it's a table I need a Matrix to be able to drill down to another level.
The problem is there when we add more level.
Hi @vbourbeau ,
Maybe you could refer to below link about rank with hierarchy:
https://dataninjago.com/2017/12/11/dax-ranking-with-hierarchy-drill-down/
Regards,
Daniel He
User | Count |
---|---|
86 | |
82 | |
68 | |
66 | |
55 |
User | Count |
---|---|
123 | |
100 | |
90 | |
83 | |
66 |