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 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!

 

 

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 

     

1 Reply

  • AlB's avatar
    AlB
    Icon for Community Champion rankCommunity 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