Count items in column based on condition in another column

[Joshua-Massey]

Hi all,

I would like to count the number of times phrase occurs in a column, based on a condition in a different column, can this be done?

please see below:

I want to count how many times "Not started" appears in the status column for each distinct ID. So the answer in the example above would be 3, as "Not started" appears at 3 different ID's

Thanks

[Avantika-Thakur]

Hi @Joshua-Massey ,

Please try using this measure -> 

Count of status = CALCULATE(DISTINCTCOUNT('Table'[ID]),ALLEXCEPT('Table','Table'[Status])).

Also, please accept the solution if this helps you achieve your results.

Thanks!

Avantika

[tackytechtom · Accepted solution]

Hi @Joshua-Massey ,

How about this:

Here the DAX measure:

MeasureDistinnctCount = 
CALCULATE ( DISTINCTCOUNT ( Table54[ID] ), Table54[STATUS] = "Not started" )

Let me know if this helps 🙂

/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/

[Joshua-Massey]

It works! thank you!

[amitchandak]

@Joshua-Massey , You can create a measure distinctcount(Table[ID]) , and use that in visual with status

[Joshua-Massey]

How do I make the measure show the result "Not started" count = 3 ?