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.
Hello,
I have 2 tables
The problem:
When I filter on a carrier group it shows their rank out of the list of carrier groups (this is great) but the carrier table then only ranks the carriers by the amount that are there, ex. if there are 3 carriers in a group their intial rankings lets say #5,#40, #50 then turn to 1-3. I would like their inital rankings to stay static. Any ideas?
Rank measures:
HI @Anonymous,
I think it will be help if you share some sample data for test.
How to Get Your Question Answered Quickly
Regards,
Xiaoxin Sheng
Hi @Anonymous
I think you need to avoid the filtering of the carrier group in the carrier rank. Try this:
Carrier Rank = RANKX ( ALL ( Data[CARRIER_CODE], Data[Carrier Group] ), 'Period Dimmension'[Period Selection], , 0 )
Or in fact, if carrier group filters the carriers, as I guess it does, this should probably suffice:
Carrier Rank = RANKX ( ALL ( Data[Carrier Group] ), 'Period Dimmension'[Period Selection], , 0 )
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 |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |