Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

TOPN for Ranking the top 3 elements

Hi,    I've been using TOPN to create a Ranking that looks like this:      The measures I used are:    For Country Name:  _1st Place = MAXX (     TOPN (         1,    ...
  • Anonymous's avatar
    Anonymous
    3 years ago

    Found a measure that works in this thread: https://community.powerbi.com/t5/Desktop/Top-Salesperson-displayed-in-a-card/m-p/598439 

    Need to see if I can add another criteria of ranking to make it error proof (in case there are equal points in the first places). Please let me know if I can add anything to make this happen. 

    _Top country =
    VAR temp_table =
        SUMMARIZE (
            ALL ( 'GSW Active'[Country] ),
            'GSW Active'[Country],
            "SalesTotalValue", SUM ( 'GSW Active'[Total Points] )
        )
    RETURN
        CALCULATE (
            MAX ( 'GSW Active'[Country] ),
            FILTER (
                ADDCOLUMNS ( temp_table, "Rank", RANKX ( temp_table, [SalesTotalValue] ) ),
                [Rank] = 1
            )
        )
Anonymous's avatar
Anonymous
Not applicable
3 years ago

I tried using the Filters Panel as well: