How to display maximum value on card

[andrewtan1993]

Dear Power BI community,

I am trying to find out the most visited gate and display it on a card. I managed to find the most visited gate (G_15_CP15.7 as shown in the table) but I don't know how to display this information on the card. Does anyone know how I can navigate around with the functions on Power BI in order to allow me to reflect the most visited gate on a card? 🙂 

Thanks in advance!

[AlB · Accepted solution]

Hi @andrewtan1993 

You need to provide some more detail. How do you determine the most visited gate exactly?

Try something like this:

Measure =
CALCULATE (
    DISTINCT ( Table1[Gate_Handheld] ),
    TOPN (
        1,
        DISTINCT ( Table1[Gate_Handheld] ),
        CALCULATE ( COUNT ( Table1[Gate_Handheld] ) ), DESC
    )
)

You'll probably have to update the CALCULATE ( COUNT ( Table1[Gate_Handheld] ) ) part to adapt it to your needs

Please mark the question solved when done and consider giving a thumbs up if posts are helpful.

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

Cheers