Forum Discussion
Filter on the greatest value
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! 🙂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!
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!
It works perfectly,
Thanks a lot for your help!!!
Rémy