Forum Discussion

PBNikr's avatar
PBNikr
Helper I
6 years ago
Solved

Using TOP N and retrieving only one result, filtering on multiple values

 

I have a table that has been filtered using TOP N visual filter (filtered on top 1, Amount).

It shows the following 4 values, example:

 

 

I would like to perform another TOP N on the values, this time filtering on the maximum % value. The values would be separate measures used in cards, example:

Is there any way of doing this using measures? (I am using a tabular model - live connection)

Need Help
  • v-eachen-msft's avatar
    v-eachen-msft
    6 years ago

    Hi PBNikr ,

     

    You could use Multi-row card visual to show the result. Then create a new measure:

    Measure 2 =
IF ( MAXX ( ALL ( 'Table (2)' ), [%] ) = [%], 1, 0 )

    Then put it in the filter.

    Here is the result.

     

     

1 Reply

  • v-eachen-msft's avatar
    v-eachen-msft
    Community Support
    6 years ago

    Hi PBNikr ,

     

    You could use Multi-row card visual to show the result. Then create a new measure:

    Measure 2 =
IF ( MAXX ( ALL ( 'Table (2)' ), [%] ) = [%], 1, 0 )

    Then put it in the filter.

    Here is the result.