Forum Discussion
Robert14358
Resolver III
Resolver IIIDAX OR and FILTER
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(Swit...
figured it out becuase of Marco 🙂
(ECN) ECN Item #'s (P1) =CALCULATE([(ECN) ECN Item #'s],FILTER(CROSSJOIN(Dim_ECN,'Fact_ECN (Multi-Function)'),(Dim_ECN[ECN_Hotwork_Flag_Final] = MAX(Switch_P1[Hotwork?]) &&'Fact_ECN (Multi-Function)'[ECN_Multi_BLK_Inchstone] >= MIN(WhatIF_P1[WhatIF_Inchstone_P1]) &&'Fact_ECN (Multi-Function)'[ECN_Multi_BLK_Inchstone] <= MAX(WhatIF_P1[WhatIF_Inchstone_P1]))|| Dim_ECN[ECN_FG_Flag] = "Yes"))
Robert14358Resolver III
Resolver IIIfigured it out becuase of Marco 🙂
(ECN) ECN Item #'s (P1) =
CALCULATE([(ECN) ECN Item #'s],
FILTER(
CROSSJOIN(Dim_ECN,'Fact_ECN (Multi-Function)'),
(
Dim_ECN[ECN_Hotwork_Flag_Final] = MAX(Switch_P1[Hotwork?]) &&
'Fact_ECN (Multi-Function)'[ECN_Multi_BLK_Inchstone] >= MIN(WhatIF_P1[WhatIF_Inchstone_P1]) &&
'Fact_ECN (Multi-Function)'[ECN_Multi_BLK_Inchstone] <= MAX(WhatIF_P1[WhatIF_Inchstone_P1])
)
|| Dim_ECN[ECN_FG_Flag] = "Yes"
)
)