Forum Discussion
rodrigodsilva
7 years agoNew Member
Getting Wrong Total If Statement
Hi Everyone. So, I have this table where the Scheduled column represents the number of measurements planned to take on the specific asset for a specific month and "Done" which represents the real...
- 7 years ago
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
- 7 years ago
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.
rodrigodsilva
7 years agoNew Member
Thank you very much Ashish_Mathur and Greg_Deckler it work perfectly....
Ashish_Mathur
Super User
7 years agoYou are welcome.