Forum Discussion
Getting Wrong Total If Statement
This looks like a measure totals problem. Very common. See my post about it here: https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376
Hi,
Try these measures:
Done More than Scheduled = SUMX(FILTER(SUMMARIZE(VALUES(Table[Asset]),[Asset],"ABCD",[Done]-[Scheduled]),[ABCD]>0),[ABCD])
Not Done = SUMX(FILTER(SUMMARIZE(VALUES(Table[Asset]),[Asset],"ABCD",[Scheduled]-[Done]),[ABCD]>0),[ABCD])
Hope this helps.
Super UserHi,
Try these measures:
Done More than Scheduled = SUMX(FILTER(SUMMARIZE(VALUES(Table[Asset]),[Asset],"ABCD",[Done]-[Scheduled]),[ABCD]>0),[ABCD])
Not Done = SUMX(FILTER(SUMMARIZE(VALUES(Table[Asset]),[Asset],"ABCD",[Scheduled]-[Done]),[ABCD]>0),[ABCD])
Hope this helps.
Thank you very much Ashish_Mathur and Greg_Deckler it work perfectly....
- Ashish_Mathur
You are welcome.
