topic Measure: how to display same MAXX value in a matrix when multiple months are selected in DAX Commands and Tips

Measure: how to display same MAXX value in a matrix when multiple months are selected

Anonymous — Thu, 04 Aug 2022 21:44:14 GMT

I created a measure called MaxBirths, that would show the highest level of Births for all countries in a matrix. If I select any month on my slicer, the matrix looks perfectly fine:

However, if I select multiple months, or all months in a year, it sums them all up like this:

If I select 'All months', and the highest births in ASIA were witnessed, for example, in China in May - then that's the number I would like to be displayed for both China and ASIA rows, not the sum.

Any ideas how I could accomplish that?

My current formula:

MaxBirths = MAXX (VALUES( 'Table'[Country] ), CALCULATE ( COUNT ( 'Table'[Births] ) ) )

Will appreciate any advice, have spent hours on this!

Re: Measure: how to display same MAXX value in a matrix when multiple months are selected

amitchandak — Fri, 05 Aug 2022 01:41:10 GMT

Anonymous , Try like

MaxBirths = MAXX (Summarize('Table', 'Table'[Country], 'Table[Month] ), CALCULATE ( COUNT ( 'Table'[Births] ) ) )

Re: Measure: how to display same MAXX value in a matrix when multiple months are selected

daXtreme — Fri, 05 Aug 2022 08:19:02 GMT

DEFINE MEASURE Births[#Births] = SUM( Births[Births] ) MEASURE Births[Max #Births] = CALCULATE( MAXX( SUMMARIZE( Births, Births[Country], Births[Period] ), Births[#Births] ), ALLSELECTED( Births[Period] ) )