Forum Discussion
Solved
Incorrect value on the total sum
I have a calculations that shows the total residual value of -316 on the home move category on Excel but on powerbi, it is showing -1 on other (includ. impact upgrades). I want it to show -316 on Hom...
Hi francsaaa ,
A similar display effect can be achieved by the following formula.
result_ = VAR sum_ = CALCULATE ( SUM ( 'Table'[Value] ), ALL ( 'Table' ) ) RETURN IF ( MAX ( 'Table'[Cate] ) = "Home move", sum_, IF ( HASONEVALUE ( 'Table'[Cate] ), BLANK (), BLANK () ) )Best Regards,
Adamk KongIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
