Forum Discussion

Robert14358's avatar
Robert14358
Icon for Resolver III rankResolver III
3 years ago
Solved

DAX 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(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")
)
)
Need Help
  • Robert14358's avatar
    Robert14358
    3 years ago

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

1 Reply

  • Robert14358's avatar
    Robert14358
    Icon for Resolver III rankResolver III
    3 years ago

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