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

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

Hi Anonymous

 

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

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hello

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