Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Dear Team,
I am trying to create a Rank column (not measure) based on the total sales per customer in my dataset.
Rank column = RANKX( ALLSELECTED('Dataset'[Customer]), CALCULATE( SUM('Dataset'[Sales]), FILTER(ALLSELECTED('Dataset'), 'Dataset'[Customer] = EARLIER('Dataset'[Customer]) ) ), , DESC)
The formula worked fine until... I apply a query filter (say on the slicer on the material column).
I have tried to debug the formula quite a bit but I have the impression, that DAX cannot apply the ALLSELECTED query filter when the FILTER is nested inside the RANKX + CALCULATE functions.
What makes me think that is that the following formula works fine.
Sales by Customer = CALCULATE( SUM('Dataset'[Sales]), FILTER(ALLSELECTED('Dataset'), 'Dataset'[Customer] = MAX('Dataset'[Customer]) ) )
Thanks to all in advance!
Solved! Go to Solution.
Thank you very much for taking the time to look into my issue!
This is exactly the result I am expecting except the Rank needs to be column and not a measure.
(Because I want to apply a RunningSum based on the rank column).
Best regards
Michael
Oh thanks Lydia, I missed out this key concept.
I will then think to achieve what I am looking for.
Thanks for your help.
Best regards
Michael
@Maikeru,
Please check the DAX in the following PBIX file.
https://1drv.ms/u/s!AhsotbnGu1Nok2nX8pAE9CsexCEn
Regards,
Lydia
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
97 | |
78 | |
63 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |