Hi I have a powerpivot formula below. It works, but only with what I've put directly in the formula. Is there a way to have it driven from a slicer or table filter?
ONLY LARGE:=IF(CALCULATE([ON HAND + IN TRAN TOTAL],'tblInvSkuMaster'[id_link_2]="SIZE Alpha L/G")=[ON HAND + IN TRAN...