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.
My rank measure works well when only introducing the ranked items, but when I introduce a category for each item (in this example, it's a geographic region) the rank measure returns false ties and skips unused rank numbers. See screenshot below, where the table on the left omits the geograhic location, and the table on the right includes it.
Generically, the rank and ranked measure look like this:
% RANK =
RANKX (
ALLSELECTED ( 'Dimension'[Item] ),
CALCULATE ( [% Measure], ALLEXCEPT ( 'Dimension', 'Dimension'[Item] ) )
)
% Measure =
DIVIDE (
SUM ( 'FACT_1'[COLUMN_1] ),
SUM ( 'FACT_2'[COLUMN_2] ),
BLANK()
)
Am I missing something to control for the additional category added to the visual? My understanding is that this should only come into play if I wanted to rank within each category, but this rank measure is independent of the category.
NOTE: I'm trying to replicate within a dummy dataset to share but have not been successful yet.
Solved! Go to Solution.
Resolved this with the updated measure:
% RANK =
RANKX (
ALL ( 'Dimension' ),
CALCULATE ( [% Measure], ALLEXCEPT ( 'Dimension', 'Dimension'[Item], 'Dimension'[Category]) )
)
Resolved this with the updated measure:
% RANK =
RANKX (
ALL ( 'Dimension' ),
CALCULATE ( [% Measure], ALLEXCEPT ( 'Dimension', 'Dimension'[Item], 'Dimension'[Category]) )
)
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 | |
100 | |
75 | |
73 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |