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/
tackytechtom
Most Valuable Professional
Most Valuable ProfessionalHi 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/
It works! thank you!
