cancel
Showing results for
Did you mean:
Helper I

## Countif with Multiple Conditions

Hi, Consider a table

 Date ID Type 21/09/2022 A S 21/09/2022 A B 21/09/2022 B S 21/09/2022 C S

Need a measure to calculate the distinct count of ID if there is only Type = S date wise

3 REPLIES 3
Helper I

It counts other IDs as well. I need only the Distinct Count of those IDs containing Type = "S" only not other than "S"

Solution Sage

Try this:

`Count = CALCULATE(DISTINCTCOUNT(Table[ID]), Table[Type] = "S")  `

Then put it in a table together with the date field to see by date.

Helper I

For Example:
If the ID has 2 entries containing Type "S" & "B" then it should be excluded from the required distinct count
If the ID has 2 Entries containing Type "S" & "S" then it should be counted

Announcements

#### Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

#### Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

#### Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

Top Solution Authors
Top Kudoed Authors