Clear all filters for a specific column

[opl12]

I'm new to PBI... can you help?

On "Report Tab", I have several columns that change the value according to a date selection that is in a slicer

I would like column "1" not to change its value when selecting any date... I would like only the other columns to change the value when changing the date

[opl12]

Obrigado!!!

[Preeti_Yadav · Accepted solution]

Hi @opl12 ,

You can try using ALL() dax  which will remove the all filters which applied prior:

Sales All Products = CALCULATE([Sales],ALL(DimProduct))

Or you may refer below link:

https://docs.microsoft.com/en-us/dax/all-function-dax 

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!

Regards,

Preeti Yadav

[amitchandak]

@opl12 , I am assuming you taking of measure in a same visual.

if yes, then you can use removefilters

calculate([measure1], removefilters(Date[date])

refer: https://www.linkedin.com/pulse/five-recent-power-bi-functions-you-should-use-more-often-amit-chandak

if you looking for one visual to filter and another should not, then you need interactions

https://docs.microsoft.com/en-us/power-bi/service-reports-visual-interactions