I am trying to remove one filter from this DAX formula but it is not working. I would use ALLEXCEPT() but there are so many other filters I need to keep that REMOVEFILTERS() seemed like the best option here.
Any thoughts would be greatly appreciated!
Group Differentiation Market =
VAR s = SUMMARIZE(ALLSELECTED(pbix_cr_quads),
pbix_cr_quads[upc], "diff", [Mkt Differentiation])
CALCULATE(AVERAGEX(s, [diff]), REMOVEFILTERS(pbix_cr_quads[product_level]))