Forum Discussion
Rena
Resolver II
2 years agoMeasure to remove one filter but add another
I have a PBI with multiple data tables. I am trying to do a simple basically sumif but can't seem to make it work. I have 10 plants that make different products. 3 of those plants all make prod...
Rena
Resolver II
2 years agoI had to throw a sumx() around it, and massage it a bit since I couldn't switch my filter to volume due to other tables on the same page needing the material map, but changing the formula around to get rid of the calculatetable worked like a charm!
Thank you so much for your help! I had spent days on this!!