Forum Discussion
Solved
Count( if column value = string)
I have a column named Placement containing mixed data values of
N/A
NO PLACMENT
the client name, or
blank
I would like a total count for each individual data value.
How can I achieve this please? a dax formula for Count( if column value = string)?
TIA
You can just drop the placement column again and summarized as count.
and measure if need it would bePlacement Count = COUNTA(MyTable[Placement])
1 Reply
You can just drop the placement column again and summarized as count.
and measure if need it would bePlacement Count = COUNTA(MyTable[Placement])