Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to 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,
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
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
User | Count |
---|---|
102 | |
90 | |
80 | |
71 | |
70 |
User | Count |
---|---|
114 | |
100 | |
97 | |
72 | |
68 |