RANKX formula help

[ReikoK]

Hi eveyone!

Problem is , that I cannot figure out how keep and rank only these brands, which only has value in GRP column. At the moment it considers all the brands (I know, that I have ALL function in my code).

Code: 

GRP rank =

VAR lastyear = MAX(Calender[Year])

VAR _rank =

    RANKX(ALL('FINAL data'[Main brands]); [Last year GRP];;DESC;Dense

    )

VAR _other =

    CALCULATE(IF ( MAX ( 'FINAL data'[Main brands] ) = "OTHERS"; 0;_rank); Calender[Year] = lastyear)

RETURN

    _other

How the table looks with GRP rank measure at the moment

Sample data and PBIX: https://we.tl/t-6fUewOOSRb

[lbendlin]

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

Do not include sensitive information or anything not related to the issue or question.

If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...

Please show the expected outcome based on the sample data you provided.

Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...

[ReikoK]

Sample data and PBix is here:

https://we.tl/t-6fUewOOSRb

[lbendlin]

You need to filter by GRP, something like this:

VAR _rank =
    RANKX(FILTER(ALLSELECTED('FINAL data'[Main brands]),[Total GRP]>0),[Viimase aasta GRP],
        ,
        ASC,
        DENSE
    )

You seem to have a few too many measures, and a lot of measure tables.  Please don't uses ADDCOLUMNS(),  , use something like

TV mõõdikud = {1}

[ReikoK]

Did not solved my problem, but managed to find the solution myself. Thank you for helping!