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.
Hi,
I am trying to filter a list of Top N hospitals based on a value using Top N what if slicer selection. I have different other measures I need to show in the table visual to users too. It works fine when I just use the Test measure that Rankx is performing on but when I add other measures in the visual, the rankx DAX doesn't work.
Hospital_Name | CustomHospitalType | Custom_IDN | FullAddress | Test | Other Measure |
A | Hospital | StandAlone | CT,06053 | 100$ | 10% |
B | Hospital | StandAlone | CA,90638 | 98$ | 15% |
C | Hospital | StandALone | IL,60521 | 95$ | 12% |
My Current formula:
Solved! Go to Solution.
Thanks a lot for looking into it. I was able to do it by doing rank as measure
Thanks a lot for looking into it. I was able to do it by doing rank as measure
Hi @Fuhrer786
Congratulations, if the issue has been solved, please adopt your solution to help others.
Best Regards,
Link
Hi @Fuhrer786,
You can try to use RANKX by creating calculated column.
You can refer this related post to implement the dax conversion.
So that the Rankx results are not affected by the line context.
Best Regards,
Link
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 |
---|---|
114 | |
99 | |
83 | |
70 | |
60 |
User | Count |
---|---|
150 | |
115 | |
104 | |
89 | |
65 |