Remove Filters Not Working in this DAX Formula

[rmcconnell340]

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]))​

[Jihwan_Kim · Accepted solution]

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] )