Forum Discussion

Regular Visitor

7 years ago

Solved

Dynamic Calculation based on Attribute across relationships

HI, I'm having an issue with some caluclations I need to perform. My first table looks something like this - Data Name | unit | amount John | B | 5 Paul | A | 10 fooo | B ...

7 years ago

Once you have created a One-To-Many relationship, you can do it like this:

=
SUMX (
    VALUES ( Assumptions[Cost of Sales] ),
    Assumptions[Cost of Sales] * CALCULATE ( SUM ( Data[amount] ) )
)

Solution Sage

7 years ago

Once you have created a One-To-Many relationship, you can do it like this:

=
SUMX (
    VALUES ( Assumptions[Cost of Sales] ),
    Assumptions[Cost of Sales] * CALCULATE ( SUM ( Data[amount] ) )
)