Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Hi @CESARADVINCULA,
Please share the pbix file with us. Do remove sensitive data before sharing.
Best Regards,
Qiuyun Yu
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
111 | |
92 | |
84 | |
66 |