cancel
Showing results for
Did you mean:
Highlighted
Member

## 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.

1 ACCEPTED SOLUTION

Accepted Solutions
Super User III

## Re: Capture values based on max count

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
)
)```
Try my new Power BI game Cross the River
5 REPLIES 5
Super User III

## Re: Capture values based on max count

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
)
)```
Try my new Power BI game Cross the River
Member

Frequent Visitor

## Re: Capture values based on max count

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

Thanks

Member

## Re: Capture values based on max count

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

Frequent Visitor

## Re: Capture values based on max count

It works. Thank you.

Announcements

#### Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

#### Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

#### January 2020 Community Highlights

Make sure you didn't miss any of the things that happened in the community in January!

Top Solution Authors
Top Kudoed Authors