Remove Filters Not Working in this DAX Formula

rmcconnell340 — Fri, 26 May 2023 16:47:02 GMT

Hi,

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]) RETURN CALCULATE(AVERAGEX(s, [diff]), REMOVEFILTERS(pbix_cr_quads[product_level]))

Re: Remove Filters Not Working in this DAX Formula

Jihwan_Kim — Sat, 27 May 2023 06:37:00 GMT

Hi,

I am not sure how your datamodel looks like, but please try something like below whether it suits your requirement.

Group Differentiation Market = VAR _s = ADDCOLUMNS ( SUMMARIZE ( ALLSELECTED ( pbix_cr_quads ), pbix_cr_quads[upc] ), "@diff", CALCULATE ( [Mkt Differentiation], ALL ( pbix_cr_quads[product_level] ) ) ) RETURN AVERAGEX ( _s, [@diff] )

topic Remove Filters Not Working in this DAX Formula in DAX Commands and Tips

Remove Filters Not Working in this DAX Formula

Re: Remove Filters Not Working in this DAX Formula