Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

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

Need Help

3 Replies

  • JorgePinho's avatar
    JorgePinho
    Solution Sage
    3 years ago

    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.

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      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 

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

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