Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

How to display maximum value on card

  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 ho...
Need Help
Show and Tell
Tips and Tricks
  • AlB's avatar
    AlB
    5 years ago

    Hi Anonymous 

    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 

     

AlB's avatar
AlB
Community Champion
5 years ago

Hi Anonymous 

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