DAX OR and FILTER

[Robert14358]

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")
)

)

[Robert14358 · Accepted solution]

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"

    )

)