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

 

Why not a simple table of 5858 Products that meet these criterion?

 

Product_ID

989879
9989799 

---

----

 

 

Component ID is redundant because we already know they have all 3 X components

RezaAzimi's avatar
RezaAzimi
Advocate I
8 years ago

but right now the measure only counts the number so I tried to do a "filter" on the existing dataset but no result is showing up. 

 

 

so the simple table you talk about it - needs to come from the existing dataset?

  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    Community Champion
    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
)

     

  • RezaAzimi's avatar
    RezaAzimi
    Advocate I
    8 years ago

    thank you for the help. it was really helpful:)