Forum Discussion
Rankx Measure with Filter
Hello, I am trying to adjust a current Ranking Measure to exclude certain Geographies from the Ranking. This is the current measure: Vol Sales Rank Geo =
RANKX (
FILTER (
...
Try iterating over just geography, and I assume vol sales does return blank, not 0
Vol Sales Rank Geo =
RANKX (
FILTER (
ALLSELECTED('LatestSizes'[geography]),
NOT ( ISBLANK ( [Vol Sales] ) )
),
[Vol Sales] ,
,
DESC,
Dense
)+0