Minimum of filtered values in every row of table/matrix

[froebm]

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

[froebm]

Thank you so much. It worked!

[vicky_ · Accepted solution]

try and replace ALL() with ALLSELECTED().