Forum Discussion
Report level filter not working on a calculation
I have a report that calculates how much product we have on order of a given product. To get the results, I have a "SUM" calculation from a different table. I have a calculation that looks like ...
unclejemima you are trying to perform a calculation based on the model which doesn't support it. First, you need to think outside the Power BI, if you have to perform this calculation manually, how you will do it, and if you are able to solve that then provide the logic.
Ok. Thank you parry2k
Can you tell me how to apply a filter to my calculation to remove SUPPLIER-A? The supplier name exists in the STOK table where the calculation is made so I would assume this is a easy thing to do?
Qty-PO_P&A = calculate(sum('Stok'[QTY-OnSentPO])+calculate(SUM(('Stok'[QTY-OnPendingPO]))))