Forum Discussion

unclejemima's avatar
unclejemima
Icon for Post Patron rankPost Patron
2 years ago

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 ...
Need Help
parry2k's avatar
parry2k
Icon for Super User rankSuper User
2 years ago

unclejemima 

calculate(sum('Stok'[QTY-OnSentPO]), TabeSupplier[Supplier] <> "Supplier A" )
+
calculate(SUM('Stok'[QTY-OnPendingPO]), TabeSupplier[Supplier] <> "Supplier A" )