Forum Discussion

francsaaa's avatar
francsaaa
Regular Visitor
2 years ago
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...
Need Help
Show and Tell
  • Anonymous's avatar
    Anonymous
    2 years ago

    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 Kong

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

MNedix's avatar
MNedix
Icon for Solution Sage rankSolution Sage
2 years ago

It's hard to say without looking at the measures/calculations. It could be anything ranging from different rounding to filters and relationships.