Forum Discussion
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...
Hi Anonymous
Use this formula in a measure
MaxCount = MAXX ( VALUES ( 'Table'[month] ), CALCULATE ( COUNT ( [id] ) ) )
Best Regards
Maggie
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
Community Support
Community SupportHi Anonymous
Use this formula in a measure
MaxCount = MAXX ( VALUES ( 'Table'[month] ), CALCULATE ( COUNT ( [id] ) ) )
Best Regards
Maggie
v-juanli-msft Thanks a lot