Forum Discussion
Use slicer visual with multiple fields within RANKX formula - make it dynamic
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Thank you. Hmmm... I don't think I have time to create fake data for all of the tables involved. I can't provide the actual data for security concerns. Basically, each field in the slicer visual comes from 2 lookup tables. The Manager (5 managers) and OPCO (9 different OPCOs) come from the OPCO lookup. The Supervisor (22 supervisors) and Garages (103 garages) come from the Garage Lookup.
I have 12 different RANKX measures in the data. I need to see all 12 measures and the corresponding RANKX measures at each of the 4 operating levels when selected. I assume I need to create a nested if RANKX measure that will be able to adjust accordingly when selected in the slicer visual. Otherwise, I will need to create 48 RANKX measures (12 X the 4 operation levels) and 4 different tabs to achieve this outcome.
Are you aware how to create a RANKX formula with all 4 of the operation levels in it like a nested if statement in Excel? If that is not possible then we don't need to go any futher.
Total Equip Damage Rank = RANKX(ALLSELECTED(OPCO[OPCO]),'Good Catch'[Total Equipment Damage],,ASC,Dense)
Sorry to hear that. Can't help in that case.