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 to count the number that = TRUE.
Keep in mind I know little. I have tried TrueValuesCount = CALCULATE(COUNT('Table1'[Row]), 'Table1'[Row] IN {"TRUE"}) and a few other things, but it wont give me a proper count. Just errors.
You need a measure that filters your table with the columnName = "TRUE". Then count the rows.
COUNTROWS(FILTER( theTable, [theColumn] = "TRUE"))
