Forum Discussion

MichaelaMul's avatar
MichaelaMul
Helper III
1 year ago

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 ( ...
Need Help
v-prasare's avatar
v-prasare
Community Support
1 year ago

Hi MichaelaMul,

Thanks for reaching MS Fabric community support.

 

Deku, Thanks for your promt response. additionally refer below

 

Vol_Sales_Rank_Geo = 
VAR FilterTable =
    FILTER (
        ALLSELECTED('LatestSizes'),
        NOT ISBLANK ( [Vol Sales] ) &&
        SUM(Geography_Table[New Sort]) > 12
    )
RETURN
    IF(
        SUM(Geography_Table[New Sort]) > 12,
        RANKX (
            FilteredTable,
            [Vol Sales],
            ,
            DESC,
            Dense
        ),
        BLANK() )

 

 

Thanks,

Prashanth Are

MichaelaMul's avatar
MichaelaMul
Helper III
1 year ago

Hi!

Thank you both for your reply! I tried both and the first one just made every geography return "1" ranking. Then I tried the second one and I am getting the same problem of it starting the ranking at 3.