Forum Discussion

remychag's avatar
remychag
Frequent Visitor
6 years ago
Solved

Filter on the greatest value

Hi guys,   I am trying to filter data of a list to only display the greatest number.    Here is what I have in my Excel data: ratio 2019  55% 82% 61% 0% 113% 163% 92% 16...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi remychag,

     

    I created the following measure:

     

    HighestRatio = MAX('Table'[Ratio 2019])
     
    This will find your highest ratio, then you could display that as a card to show the highest ratio or you could use this to filter other visuals.
     
    Hope this helps! 🙂
     
  • Anonymous's avatar
    Anonymous
    6 years ago

    remychag,

     

    Yes, there are two ways you could do this.  For both visuals, you would start with a table visual.  The first way is to create a table with the ratio and country then filter the visual by the top value as shown below:

     

     

    The second way is to create a table with only the country field, filter on top N just like before, then change the visual to a Card visual.  For some reason, the card visual does not let you filter on topN, but if you start with a table visual, it will. I think the cards look a lot nicer than the table view, so I would recommend doing this.  An example of this is below.

     

    Let me know if you have any other questions!

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi remychag,

 

I created the following measure:

 

HighestRatio = MAX('Table'[Ratio 2019])
 
This will find your highest ratio, then you could display that as a card to show the highest ratio or you could use this to filter other visuals.
 
Hope this helps! 🙂
 
remychag's avatar
remychag
Frequent Visitor
6 years ago

Hi hwegman,

 

Thank you for your help, it works!!! (I'm not super familiar w/ DAX)

 

One more question: with each ratio goes a country, ex:

Ghana55%
Niger82%
Liberia61%
Sierra Leone0%
Togo113%
Senegal163%
Mali92%
Guinea160%
Ivory Coast118%

 

Under the biggest ratio, I would like to display (automatically) the correpsonding country and that's not possible with "Card" visualization.

Do you have any idea on how to do it please?

 

Rémy

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    remychag,

     

    Yes, there are two ways you could do this.  For both visuals, you would start with a table visual.  The first way is to create a table with the ratio and country then filter the visual by the top value as shown below:

     

     

    The second way is to create a table with only the country field, filter on top N just like before, then change the visual to a Card visual.  For some reason, the card visual does not let you filter on topN, but if you start with a table visual, it will. I think the cards look a lot nicer than the table view, so I would recommend doing this.  An example of this is below.

     

    Let me know if you have any other questions!

    • remychag's avatar
      remychag
      Frequent Visitor
      6 years ago

      It works perfectly,

       

      Thanks a lot for your help!!!

       

      Rémy