Forum Discussion
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...
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 )
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?
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
)
thank you for the help. it was really helpful:)