Forum Discussion
Solved
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...
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.
Greg_Deckler
Community Champion
Community ChampionThis 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