The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.
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 |
---|---|
68 | |
63 | |
59 | |
54 | |
28 |
User | Count |
---|---|
182 | |
81 | |
64 | |
46 | |
41 |