Hello All.
Is there a way to FILTER with OR here is what i need...
(ECN) ECN Item #'s (P1) =
CALCULATE([(ECN) ECN Item #'s],
OR(
FILTER(Dim_ECN,Dim_ECN[ECN_Hotwork_Flag_Final] = MAX(Switch_P1[Hotwork?])),
FILTER('Fact_ECN (Multi-Function)',
'Fact_ECN (Multi-Function)'[ECN_Multi_BLK_Inchstone] >= MIN(WhatIF_P2[WhatIF_Inchstone_P2]) &&
'Fact_ECN (Multi-Function)'[ECN_Multi_BLK_Inchstone] <= MAX(WhatIF_P2[WhatIF_Inchstone_P2]))
,
FILTER(Dim_ECN,Dim_ECN[ECN_FG_Flag] = "Yes")
)
)