Forum Discussion
unclejemima
Post Patron
Post PatronReport 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 ...
parry2k
Super User
Super Userunclejemima 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.
unclejemimaPost Patron
Post PatronOk. 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]))))