Forum Discussion
misiek5510
4 years agoHelper III
Count Custom Dax Column
Hi, I have measure that is an if statement and gives either "completed" or "not completed" output in a table and is called warehouse status. Now I have a table that display's everything correctly...
- 4 years ago
You can use it within a count like this:
COUNTROWS ( FILTER ( Base, [Warehouse Status] = "Completed" ) )I don't know if this is what you're actually trying to count though.
AlexisOlson
4 years agoSuper User
From this screenshot, it's apparent that [Warehouse Status] is a measure, not a column. This is why you cannot use it inside COUNT or as part of a boolean filter argument.
misiek5510
4 years agoHelper III
Yes it is a measure. Is there no way to perform a count on it?
- AlexisOlson4 years agoSuper User
You can use it within a count like this:
COUNTROWS ( FILTER ( Base, [Warehouse Status] = "Completed" ) )I don't know if this is what you're actually trying to count though.
- misiek55104 years agoHelper III
Thank you very much just what I needed.