cancel
Showing results for
Did you mean:
Frequent Visitor

## Multiplication of two calculated measures & wrong subtotals

hi,

I am struggling to find the right measure for calculating the subtotal at the month level for the Weighted (WTD) stock cover in weeks.
Example of row-wise calculation: (12%+27%)*7.6 = 3.0 of wtd stock cover in wks for Partner A.

In the month total I want to sum up all these results from sub-category and regional level for each Partner to get the sum shown on extreme right.

Whats the best way to get that? I have tried sumx and summarize etc. Nothing is working 😞
____
Wtd Forecast =
VAR monthly_fc = CALCULATE(Sum[FC Value]), ALLSELECTED(Product[code]), all(Product[Partner]), all(tblDate[Date]) )
VAR weekly_fc = CALCULATE(Sum[FC Value]), ALLSELECTED(Product[code]))

Return
DIVIDE(weekly_fc, monthly_fc)

____
wtd cover= CALCULATE([Days Covers]/7)*(CALCULATE([Wtd Forecast], ALL(Products[Partners]) ) )

1 ACCEPTED SOLUTION
Super User

Hi! @FAA9

SQL BI covered this topic last month, please have a look at this and see if that helps you.

https://www.sqlbi.com/articles/why-power-bi-totals-might-seem-inaccurate/

If it doesn't help, Please share the pbix file if possible.

If my response has addressed your question or concern, kindly mark this post as resolved. If you found my assistance helpful, consider giving it a thumbs.
Thanks,
Ankit Kukreja
Super User

Hi! @FAA9

SQL BI covered this topic last month, please have a look at this and see if that helps you.

https://www.sqlbi.com/articles/why-power-bi-totals-might-seem-inaccurate/

If it doesn't help, Please share the pbix file if possible.

If my response has addressed your question or concern, kindly mark this post as resolved. If you found my assistance helpful, consider giving it a thumbs.
Thanks,
Ankit Kukreja