sum of a measure is false

[graceste]

Hallo, I've been struggling with this thema for a while, 

would appreciate any help,

the measure returns value that i've expected (last available), but the sum is false

Measure = CALCULATE(sum(fValue[PR Value]);FILTER(ALLEXCEPT(fValue;'Prognose for Day');fValue[data from]=max('Prognose for Day'[for Date])))

pbix unten

https://www.dropbox.com/s/wm7klycl3e0od6r/TEST%20DayValue.pbix?dl=0

regards

grace

[v-yuezhe-msft · Accepted solution]

@graceste,

Create a new measure using DAX below.

Measure 3 = IF(COUNTROWS(VALUES('Prognose for Day'[for Date]))=1,[Measure],SUMX(VALUES('Prognose for Day'[for Date]),[Measure]))

Regards,
Lydia

[graceste]

Hi Lydia,

Measure3 works perfekt, I have changed it only a littele bit

Measure 4 = if(COUNTROWS(VALUES('Prognose for Day'[for Date]))=1;[Measure 2];SUMX(VALUES('Prognose for Day'[for Date]);[Measure 2]))

where Measure 2 is

Measure 2 = if(sum(fValue[PR Value])=BLANK();[Measure];sum(fValue[PR Value]))

Thanks again 

Best regards

grace