Total of Min() min in Measure is wrong

[scorpi73]

Hallo there,

i have a Min-Measure comparing three other Measure. but the total Row is showing the wrong Value.

MIN(Abfrage1[IST],MIN(Abfrage1[SOLL],[Plan]))

here a sample of my File:
https://www.dropbox.com/s/7lvrx9hcjm6730z/sample_Min.pbix?dl=0

thank you

[amitchandak · Accepted solution]

@scorpi73 , try

minx(values('Date'[date]),calculate(MIN(Abfrage1[IST],MIN(Abfrage1[SOLL],[Plan]))))

or

sumx(values('Date'[date]),calculate(MIN(Abfrage1[IST],MIN(Abfrage1[SOLL],[Plan]))))

[scorpi73]

Dear Amit, thank you for the Solution. it works:)