Reply
avatar user
Anonymous
Not applicable
Partially syndicated - Outbound

Countif with Multiple Conditions

Hi, Consider a table 

 

DateIDType
21/09/2022AS
21/09/2022AB
21/09/2022BS
21/09/2022CS

 

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

3 REPLIES 3
avatar user
Anonymous
Not applicable

Syndicated - Outbound

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

JorgePinho
Solution Sage
Solution Sage

Syndicated - Outbound

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.

avatar user
Anonymous
Not applicable

Syndicated - Outbound

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 

avatar user

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)