Measure for Mindate to a third column works correctly in the month, but not at year level.

[GeorgWildmoser]

Hello,

please help me with DAX. I have a measure that determines the minimum date for column 3. Usually the beginning of a month is expected.

The measure works as long as I have the month as a column in the table.

The measure stops working when I go to the year view. Then I get the beginning of the year as the result.

Thank you for your help.

Result:

Expected result (please remove the month column):

My measure:

Thank you for your help. 

[Anonymous · Accepted solution]

Thanks for the reply from lbendlin , please allow me to provide another insight: 
Hi  @GeorgWildmoser ,

I created some data:

You can try using filter(table, filter conditions), which creates a pro table in the current counting context containing the rows of the filter conditions to be calculated.

Measure =
MINX(
    FILTER('Table',
    'Table'[Column3]<>BLANK()),[date])

If the results above don't meet your expectations, Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data. We can better understand the problem and help you

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[lbendlin]

That is working as designed. Since you don't have a filter on the month the KEEPFILTERS  is ineffective.