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 TOTAL],CALCULATE([ON HAND + IN TRAN TOTAL],'tblInvSkuMaster'[id_link_2]="SIZE Alpha L/G"),"0")
I'm trying to filter the results of all products we have that we only have Larges in. So my thought was if qty on hand in large was the same as qty on hand total for all. Then it must be only larges.
Thanks
ONLY LARGE:=IF(CALCULATE([ON HAND + IN TRAN TOTAL],'tblInvSkuMaster'[id_link_2]="SIZE Alpha L/G")=[ON HAND + IN TRAN TOTAL],CALCULATE([ON HAND + IN TRAN TOTAL],'tblInvSkuMaster'[id_link_2]="SIZE Alpha L/G"),"0")
I'm trying to filter the results of all products we have that we only have Larges in. So my thought was if qty on hand in large was the same as qty on hand total for all. Then it must be only larges.
Thanks