Forum Discussion
Help on RANKX with Slicers
Hi ValentinB,
According to your description, have you checked Table[Date]?
if you want to slice by date, you'll need to create separate dimensions for Year, Quarter, etc. so that you can include them in the ALLSELECTED() statement.
kindly share your sample data and expected result to me if you don't have any confidential Information.
Article for reference:How to provide sample data in the Power BI Forum
Best Regards,
Caitlyn Yan
Anonymous ,one thing that I forgot to mentioned, in order to verify the whole period I have made a List Visualization with the values Name2 / %Extra Fuel/ Rank Position / Total Ranking.
Note: This visualisation is not altered by the slicer Name2 (using the "Edit Interactions" from the Format Tab)
By checking the List, I can see that it works for the whole period, but the moment I change the period it still kind of works but for same individual it skips a value of the Rank Position (see below photo) where for e.g. Rank 1 does not exist and the max value of Rank Position is 102 out of Total Ranking of 101...
Again, something that I dont seem to find the "why" in it.