topic Re: MINX of Measure not behaving as expected in DAX Commands and Tips

MINX of Measure not behaving as expected

Anonymous — Thu, 26 Jan 2023 23:01:36 GMT

I have a slicer to select a Country, and a table with 3 measures based on this slicer. The three measures are: Average Historical ASP, Average Material Cost, and Margin. I am trying to add a 4th measure which finds the minimum value from all values in the Margin column.

The formula I am currently using is:

Min Margin = MINX('Historical ASP', [Margin])

I would expect that with all Country values selected, it should show 3.27 as Min Margin for all rows in the above. Where am I going wrong?

Re: MINX of Measure not behaving as expected

Greg_Deckler — Thu, 26 Jan 2023 23:39:43 GMT

Anonymous Try:

Min Margin = VAR __Table = SUMMARIZE(ALL('Historical ASP'),[Country],"__Margin",[Margin]) VAR __Result = MINX(__Table,[__Margin]) RETURN __Result

Re: MINX of Measure not behaving as expected

FreemanZ — Thu, 26 Jan 2023 23:51:18 GMT

hi Anonymous

Seems on the wrong granularity, try like:

Min Margin = MINX( SUMMARIZE( 'Historical ASP', 'Historical ASP'[Country], 'Historical ASP'[PH7] ), [Margin] )

Re: MINX of Measure not behaving as expected

Anonymous — Fri, 27 Jan 2023 00:41:01 GMT

Greg_Deckler Thanks that works. Was wondering, if I wanted to measure MINX only for selected Country fields from the slicer, where do I add that in?

Re: MINX of Measure not behaving as expected

AlexisOlson — Fri, 27 Jan 2023 03:41:15 GMT

Try ALLSELECTED instead of ALL.