Forum Discussion
Solved
Wrong Total / Measure Problem
Hello,
I probably have a simple problem where i am looking for a simple way š
Measure:
Consumption = CALCULATE(SUM(Table[Value]))
When I multiply later the Consumption with Numbers I get following wrong result for the Total:
Measure Multiplication = Clients * Consumption
How do I have to change the DAX formula in the Measure Multiplication to get the right value?
Thanks!
please use
Measure Multiplication =
SUMX (
VALUES ( TableName[Segmaent] ),
[Clients] * [Consumption]
)
3 Replies
please use
Measure Multiplication =
SUMX (
VALUES ( TableName[Segmaent] ),
[Clients] * [Consumption]
)Pikachu-Power
Modify the measure as follows:Total = SUMX( VALUES ( Table[Segment] ) , [Clients] * [Consumption] )Great that's it!
