Forum Discussion
Solved
Count items in column based on condition in another column
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...
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/
amitchandak
Super User
Super UserJoshua-Massey , You can create a measure distinctcount(Table[ID]) , and use that in visual with status
How do I make the measure show the result "Not started" count = 3 ?