How can I filter a table visual on a measure?

[Anonymous]

I have a measure defined:  StartDate1Y = DATEADD(LASTDATE(GetZeroPBaseData[ProductionDate]),-1,YEAR)

I want to filter a table visual based on that measure.  For clarification, a slicer defines my production date range to be, say, May - Jun 2023.  This measure will create a second date range from Jun 2022 to Jun 2023, or rather, just that start date.  Then, I want to apply those dates to an unrelated table visual where that first slicer has been turned off.  I can't get it to work.  I'm new to PowerBI and I'm trying to learn from the middle, but I have to get it figured out by Monday.

Thanks in advance for any help.

[danextian]

Hi @Anonymous ,

You can't use a measure in a slicer, only a column can. What you can do  is to reference that measure in another measure to filter a calculation. For example:

New Measure =
CALCULATE (
    [measure or aggregation],
    FILTER ( mytable, mytable[column] = [my filter measure] )
)

If you want to get a better answer, please refer to this sticky post:

https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/3332479#M1112153 

[littlemojopuppy]

HI @Anonymous 

You cannot plug measures into slicers...only columns.

I'd suggest building the logic for a given selection of dates, calculate the measure for the intended dates.  You will need a date table and it marked appropriately.  But after that, there are Time Intelligence functions that will make this really easy.

Hope this helps!