Forum Discussion

RezaAzimi's avatar
RezaAzimi
Advocate I
8 years ago
Solved

Countif with multiple criteria

Hi,    I have tried to search for a solution for this issue but I could not find any suitable although it requires a countif function to a large extent. But anyways, I have a table that shows the r...
Need Help
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    8 years ago

    HI RezaAzimi

     

    Go to Modelling Tab and press the NEW TABLE button and enter this formula

     

    You will get a list of all 5854 products that meet these criterion

     

    NEW TABLE =
FILTER (
    SUMMARIZE (
        FILTER (
            PumpComponents,
            PumpComponents[Module] = "X1"
                || PumpComponents[Module] = "X2"
                || PumpComponents[Module] = "X3"
        ),
        PumpComponents[Product_PN],
        "Distinct_Count", DISTINCTCOUNT ( PumpComponents[Module] )
    ),
    [Distinct_Count] = 3
)

     

Zubair_Muhammad's avatar
Zubair_Muhammad
Community Champion
8 years ago

HI RezaAzimi

 

May be. Try these

 

X Ones=
CALCULATE (
    DISTINCTCOUNT ( Pump_Components[Product_PN] ),
    Pump_Components[Module] = "X1"
        || Pump_Components[Module] = "X2"
        || Pump_Components[Module] = "X3"
)

 

Y Ones =
CALCULATE (
    DISTINCTCOUNT ( Pump_Components[Product_PN] ),
    Pump_Components[Module] = "Y1"
        || Pump_Components[Module] = "Y2"
        || Pump_Components[Module] = "Y3"
)
Zubair_Muhammad's avatar
Zubair_Muhammad
Community Champion
8 years ago

RezaAzimi

 

For All Modules we can simply use

 

All(X1 to Y3) =
CALCULATE ( DISTINCTCOUNT ( Pump_Components[Product_PN] ) )