Forum Discussion
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!