cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Frequent Visitor

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!

 

most_frequent_use_gate.PNG

 

1 ACCEPTED SOLUTION
Super User III
Super User III

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 

SU18_powerbi_badge

 

View solution in original post

1 REPLY 1
Super User III
Super User III

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 

SU18_powerbi_badge

 

View solution in original post

Helpful resources

Announcements
secondImage

Congratulations!

We are excited to announce the Power BI Super Users!

Wave Release 2

Check out the updates in Power BI.

Overview of Power BI 2020 release wave 2!

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

Top Solution Authors