Forum Discussion
Solved
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...
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.
Yes basically when I get as far as:
Yes = CALCULATE ( COUNT ( Table1[Col1] ),
It will find Table1 but will not find Col1 and it just highlights it (No measures are shown), but when the reamaining of the forula is typed :
Table1[Col1] = "Yes" )
in the second part it finds the Table1 and Col1 fine.
Does it makes sense?
Can you verify that [Col1] is a calculated column rather than a measure?
The icon will look different (a table vs a calculator).
Yes it was created in Data View > New Column, I think that's a calculated column. Its not a measure but measures are also not visible when trying to use the formula above.
thats the icon.