Forum Discussion

carlenb's avatar
carlenb
Icon for Advocate II rankAdvocate II
2 years ago
Solved

How to get the relative value? Model attached

Hi,   I'm trying to wrap my head around this. I've attached the model here: https://drive.google.com/file/d/1yIC3LKIDAaCzr5LbQyg5k6w2p4poSNB3/view?usp=sharing  Also see screenshot of the model bel...
  • tamerj1's avatar
    tamerj1
    2 years ago

    Hi carlenb 
    Please refr to attached

    Sales Volumne = 
SUMX ( 
    VALUES ( DimProject[ID] ),
    SUMX ( 
        CALCULATETABLE ( Sales ),
        Sales[Quantity] * Sales[Price]
    )
        * CALCULATE ( MAX ( DimProjectPlan[Number of starts] ) )
)
tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
2 years ago

Hi carlenb 
Please refr to attached

Sales Volumne = 
SUMX ( 
    VALUES ( DimProject[ID] ),
    SUMX ( 
        CALCULATETABLE ( Sales ),
        Sales[Quantity] * Sales[Price]
    )
        * CALCULATE ( MAX ( DimProjectPlan[Number of starts] ) )
)
carlenb's avatar
carlenb
Icon for Advocate II rankAdvocate II
2 years ago

Many thanks tamerj1 - I got it to work as expected 🙂 thanks for submitting the solution as well!