Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Power BI value DAX Aggregation sum issue

Here is my source data: I then create two Tables "Version_1" and "Version_2".  I then create slicers to compare different versions: Value V1, Value V2, Quarter V1, and Quarter V2 are al...
Need Help
  • Icey's avatar
    Icey
    5 years ago

    Hi Anonymous ,

     

    The total value of [Value V2 Adj] = 0 is correct. The calculation logic is like below:

    Please try to modify your measure as amitchandak mentioned:

    Value V2 Adj 2 =
SUMX (
    VALUES ( 'Table'[Customer] ),
    IF ( [Quarter V1] <> [Quarter V2], 0, [Value V2] )
)

     

     

    Best Regards,

    Icey

     

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

Icey's avatar
Icey
Community Support
5 years ago

Hi Anonymous ,

 

The total value of [Value V2 Adj] = 0 is correct. The calculation logic is like below:

Please try to modify your measure as amitchandak mentioned:

Value V2 Adj 2 =
SUMX (
    VALUES ( 'Table'[Customer] ),
    IF ( [Quarter V1] <> [Quarter V2], 0, [Value V2] )
)

 

 

Best Regards,

Icey

 

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