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/
Avantika-Thakur
Solution Supplier
Solution SupplierHi 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