Forum Discussion

Furio_P's avatar
Furio_P
Frequent Visitor
2 years ago

Slicer Filter (data) for a specific DAX Measure

Hello everyone,

I could use a hand: is it possible to create a visual filter object (slicer) that interacts only with certain measures created in DAX from a table?
In my specific case, I have a table that refers to a calendar and records a series of columns with events. The measure counts certain events that have a specific value in the table over the entire time span of the table.
I would like to create a temporary interaction that, by selecting a month, applies that measure only to the selected month, and not to the entire table. This is because the measure populates a table that compares two months of that data, and, in turn, a third measure calculates the difference.
Currently, what I have done is include in the DAX formula of the measure the month/year I am looking for, but every time I have to change the syntax of the formulas to measure the right data, and this is impractical.
Having two slicers, one for Measure A and the other for Measure B, that update the measures over time would free me from this constraint.
Thank you very much!

2 Replies

  • If you don't want a particular measure being affected, you can always use REMOVEFILTERS(Slicer[Field]) as part of the calculate arguments.

  • Furio_P's avatar
    Furio_P
    Frequent Visitor

    thank you; I assume that I've to study more DAX. I want to know more about REMOVEFILTERS. Thank you