Minimum of filtered values in every row of table/matrix

froebm — Thu, 30 Nov 2023 17:48:04 GMT

Hi at all,

I have a dates and several formated date values, like Monthname, monthnumber etc.

In a Matrix I show the month name. With a measure I wanted to show the lowest filtered month number in every row.

If I use the following formular

MinMonth = CALCULATE ( MIN(tblDateTable[monthnumber], ALL(tblDateTable) )

I get the same value in every row (as seen on the image below), but the wrong one. Sure, because I use the filter from monthnumber with "ALL".

However, the desired result in this example should be 4 in each row. How can I achieve this? I tried everything. I either get the respective month number per row or the lowest value of the unfiltered date table.

The MontName

Thank you in advance and best regards,

Max

Re: Minimum of filtered values in every row of table/matrix

vicky_ — Thu, 30 Nov 2023 23:08:24 GMT

try and replace ALL() with ALLSELECTED().

Re: Minimum of filtered values in every row of table/matrix

froebm — Mon, 04 Dec 2023 09:09:36 GMT

Thank you so much. It worked!

topic Re: Minimum of filtered values in every row of table/matrix in DAX Commands and Tips

Minimum of filtered values in every row of table/matrix

Re: Minimum of filtered values in every row of table/matrix

Re: Minimum of filtered values in every row of table/matrix