UNIQUE MAX VALUE

[Anonymous]

Hello 

I am trying to use the dax code below to find a max value. I was able to show the max value but im my chart there are 2 months with the same max value. Is it possible to show only one?

UNique_Max =

VAR MaxCount =

MAXX ( VALUES ( Table[month] ), CALCULATE ( COUNT ( [id] ) ) )

RETURN

CALCULATE (

CONCATENATEX (

FILTER (

VALUES (  Table[month] ),

CALCULATE ( COUNT ( [id] ) = MaxCount )

),

COUNT ( [id]

)

))

[v-juanli-msft]

Hi @Anonymous

Based on my understanding from your information,

The “amount” refers to the number of count of “id”,

the “Unique_Max” returns the count of “id’ for each month,

 

For example, in the above example, month1 and month2 has the same amount of 5, so what result do you want?

All rows show 5 for column “Unique_Max”, or only one row (month1 or month2?) returns 5?

Please help me clear about your requirement.

Best Regards

Maggie

[Anonymous]

I am trying to display the result of the formula in a "card visual" in powerBI, but once i have to " 2" Unique_Max such as 5 and 5, the card itself is showing "55" instead of "5". I m tryng to get only one "5". 

please let me know if i was able to explain properly

[v-juanli-msft · Accepted solution]

Hi @Anonymous

Use this formula in a measure

MaxCount = 
MAXX ( VALUES ( 'Table'[month] ), CALCULATE ( COUNT ( [id] ) ) )

Best Regards

Maggie

[Anonymous]

@v-juanli-msft Thanks a lot 

[AlB]

Hi @Anonymous

would it be possible for you to share the pbix? With dummy data if necessary

[AlB]

Hi @Anonymous

Where exactly within your code do you get the two values??

[Anonymous]

Hello

In my chart, i m displaying data from Jan to Nov and i have 2 months with the same amount.