Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Show only specific rank from table

Hi everyone,   I'm rather new to Power BI and was wondering whether there is function to only show a specific rank of a table based on a measure. E.g. I want to create a podium with 1st 2nd and 3r...
Need Help
  • johnt75's avatar
    johnt75
    4 years ago

    Try

    Rank = RANKX(
ALL(constructors),
[Points]
)
Anonymous's avatar
Anonymous
Not applicable
4 years ago

I can not filter based on a measure. It won't let me click anything, eventhough it looks like I should be able to click the dropdown menu

 

johnt75's avatar
johnt75
Icon for Super User rankSuper User
4 years ago

make sure that the Format of the Rank measure is set to Whole Number

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    It is, but I can still not use it as a Filter

    • johnt75's avatar
      johnt75
      Icon for Super User rankSuper User
      4 years ago

      at what level are you applying the filter, page or visual? because it will only work at visual level. SQL BI have an interesting article on measures as filters

      • Anonymous's avatar
        Anonymous
        Not applicable
        4 years ago

        I am applying the filter at visual level. Is it possible to get a calculated column for the Rank Function instead of a measure? 

        If so, what would it be if thats my measure?

        Rank = RANKX(
        ALL(constructors[Name]),
        [Points]
        )