Forum Discussion
ACraig08
Helper III
Helper IIISort Order is messing with measure calculations
Ok, so I have a column that I created in Power Query, Request Notice Bins. Request Notice Bins creates the following values: < 1 Month, 1 - 3 Months, 3 - 6 Months, 6 - 12 Months, 12 - 18 Months, ...
You need to remove the sort order column when performing the ranking, as well as the bin name.
Try
Request notice % Rank = RANKX ( ALL ( 'Letting Change'[Request Notice Bins], 'Letting Change'[Sort Order - Request Notice Bins] ), CALCULATE ( [Request Notice %] ), , DESC, DENSE )
johnt75
Super User
Super UserYou need to remove the sort order column when performing the ranking, as well as the bin name.
Try
Request notice % Rank =
RANKX (
ALL (
'Letting Change'[Request Notice Bins],
'Letting Change'[Sort Order - Request Notice Bins]
),
CALCULATE ( [Request Notice %] ),
,
DESC,
DENSE
)
ACraig08Helper III
Helper IIIYou are amazing thank you!!! I feel like I spent an entire day trying to look up and figure that out!