Forum Discussion
Measure with two filters (one with function ALL)
Hi, I have measure like this: ``` Measure= VAR __year = FORMAT ( TODAY (), "YYYY" ) VAR numerator = CALCULATE ( DISTINCTCOUNT ( Fact_Table[Order Number] ), FILTER...
dfervwrqqq
Create a helper table that contain all the distinct years.
Year
2022
2023
Measure =
var _selectedYear = MAX(HELPERTABLE[Year])
RETURN
CALCULATE (
DISTINCTCOUNT ( Fact_Table[Order Number] ),
FILTER(Calendar[Date (Year) = _selectedYear)
)
*Slicer value should be the Year column of the Helper Table
*No relationship between main table and helper table