Wrong Total / Measure Problem

[Pikachu-Power]

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!

[Fowmy]

@Pikachu-Power 

Modify the measure as follows:

Total = 
SUMX( VALUES ( Table[Segment] ) , [Clients] * [Consumption] )

[Pikachu-Power]

Great that's it!

[tamerj1 · Accepted solution]

Hi @Pikachu-Power 

please use

Measure Multiplication =

SUMX (

VALUES ( TableName[Segmaent] ),

[Clients] * [Consumption]
)