Create measure in Power BI using CALCULATE using filter that ignore slicer selection

[Anonymous]

I am trying to create a measure With calculate function which has a filter also. but when I applied that measure to the table it was not overriding the slicer.

TDP (test)* = var TDP_ITEM = CALCULATE(SUM(src_fact[WEIGHTED_DISTRIBUTION__W_]),FILTER(src_product,src_product[HIER_LEVEL_NAME] = "ITEM"))

Is there any way that I can get rid of this slicer on this DAX?

[Anonymous · Accepted solution]

Hello

you can try using ALL() on the src_product table 

Like this 

TDP (test)* = var TDP_ITEM = CALCULATE(SUM(src_fact[WEIGHTED_DISTRIBUTION__W_]),FILTER(ALL(src_product),src_product[HIER_LEVEL_NAME] = "ITEM"))

Regards