Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

UNIQUE MAX VALUE

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?   U...
Need Help
  • v-juanli-msft's avatar
    v-juanli-msft
    7 years ago

    Hi Anonymous

    Use this formula in a measure

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

     

    Best Regards

    Maggie

v-juanli-msft's avatar
v-juanli-msft
Icon for Community Support rankCommunity Support
7 years ago

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's avatar
Anonymous
Not applicable
7 years ago

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

  • AlB's avatar
    AlB
    Icon for Community Champion rankCommunity Champion
    7 years ago

    Hi Anonymous

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

  • v-juanli-msft's avatar
    v-juanli-msft
    Icon for Community Support rankCommunity Support
    7 years ago

    Hi Anonymous

    Use this formula in a measure

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

     

    Best Regards

    Maggie

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      v-juanli-msft Thanks a lot