cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
harshadsp
Post Patron
Post Patron

Capture values based on max count

Hello All,

Need your help! Is there any way that I can capture the name of crime which has max counts? With below case it should show Burglary of vehicle since its count is 715. I have a measure which gets the value of max count = 715 but not sure how to write anothet measure which will show the value corresponding to this value.

 

Capture.PNG

 

Please advise, thanks!

 

1 ACCEPTED SOLUTION
Zubair_Muhammad
Community Champion
Community Champion

Hi @harshadsp

 

Assuming your Table name is "CrimeData", try this measure

 

Most Common Crime =
VAR Maxvalue =
    MAXX (
        SUMMARIZE (
            CrimeData,
            CrimeData[CrimeType],
            "Count", COUNT ( CrimeData[CrimeType] )
        ),
        [Count]
    )
RETURN
    CALCULATE (
        VALUES ( CrimeData[CrimeType] ),
        FILTER (
            VALUES ( CrimeData[CrimeType] ),
            CALCULATE ( COUNT ( CrimeData[CrimeType] ) ) = MaxValue
        )
    )

Regards
Zubair

Please try my custom visuals

View solution in original post

5 REPLIES 5
vvibhakar
Frequent Visitor

Can you please tell me how did you create the measure that shows you the max count - 715 ?

Thanks

 

Hi, I used the following formula to get the max value.

 

Measure = MAXX ( VALUES ( table[column1] ), CALCULATE ( COUNT ( table[column2] ) ) )

 

Hope this helps, else please write again. Thanks

It works. Thank you.

Zubair_Muhammad
Community Champion
Community Champion

Hi @harshadsp

 

Assuming your Table name is "CrimeData", try this measure

 

Most Common Crime =
VAR Maxvalue =
    MAXX (
        SUMMARIZE (
            CrimeData,
            CrimeData[CrimeType],
            "Count", COUNT ( CrimeData[CrimeType] )
        ),
        [Count]
    )
RETURN
    CALCULATE (
        VALUES ( CrimeData[CrimeType] ),
        FILTER (
            VALUES ( CrimeData[CrimeType] ),
            CALCULATE ( COUNT ( CrimeData[CrimeType] ) ) = MaxValue
        )
    )

Regards
Zubair

Please try my custom visuals

View solution in original post

@Zubair_Muhammad, this is perfect!! Thank you for your assistance 🙂

Helpful resources

Announcements
2022 Release Wave 1 760x460.png

2022 Release Wave 1 Plan

Power Platform release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.

Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

Jan 2022 Dev Camp 768x460 copy.png

Power BI Dev Camp- January 27th, 2022

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

Top Solution Authors