Forum Discussion
Solved
Counting Rows with Literal TRUE or FALSE Value
No one seems to explain the simple things in DAX in a way I can understand. All my searches have come up with measures that will convert a Boolean (1/0) to a True/False within rows, but I just need...
You need a measure that filters your table with the columnName = "TRUE". Then count the rows.
COUNTROWS(FILTER( theTable, [theColumn] = "TRUE"))
Also Tried Measure = CALCULATE(COUNT('Table'[Row] = TRUE()))