SUM DOESNT WORK PROPERLY

[CESARADVINCULA]

Hi,

I have an issue about how to calculate the total of a column, if you see i am using a "what if parameter" to calculate optimal inventory based on the Turnover Target by ABC Class, the formula behind it is:

OptimalInventory =<Usage Amount> / <Turnover Target (A,B,C)>

This is the formula for the Optimal Inventory:

1_OptimalInventory = SWITCH(TRUE()
, min('Optimal Inventory Param'[ABC Class]) ="A" , SUM('Optimal Inventory Param'[Usage Amount]) / 'Turnover Target A'[Turnover Target A Value]
, min('Optimal Inventory Param'[ABC Class] ) ="B" , SUM('Optimal Inventory Param'[Usage Amount]) / 'Turnover Target B'[Turnover Target B Value]
, min('Optimal Inventory Param'[ABC Class] ) ="C" , SUM('Optimal Inventory Param'[Usage Amount]) / 'Turnover Target C'[Turnover Target C Value]
, 0 )

But if you see in the total is: 70,690,614.00

53,643,182 + 6,806,314  + 4,558,641 = 65,008,136

The total line is showing a wrong number.

Can anyone help me?

Thanks.

Regards,

Cesar

[v-qiuyu-msft]

Hi @CESARADVINCULA,

Please share the pbix file with us. Do remove sensitive data before sharing. 

Best Regards,
Qiuyun Yu