Problem of calculating the total of a measure created from other measures

[Mickael_R]

Hello everyone, I have a problem for a while.
Here is a simplified example of my data

With Delta Price, Evol to be applied (which depends on Delta Price) and Forecast (which depends on Evol to be applied and Tonnage) data which are measures calculated from other data in my database. My problem is that I can't get the total of the Forecast measure either with slicers or without.

[v-cgao-msft · Accepted solution]

Hi @Mickael_R ,

Please try this measure.

Forecast = SUMX(VALUES('Table'),[Evol to be Applied]*[Tonnage])

Best Regards,
Community Support Team Gao

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems with it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly -- How to provide sample data

[amitchandak]

@Mickael_R , how is forecast measure calculated

you can try a measure like below if you have Forecast measure

Summarize(Table, Table[Supplier], Table[tem], "_1", [Forecast] ), [_1])

[Mickael_R]

Thanks for your help, forecast = Tonnage * Evol to be applied. I don't understand what [_1] represents