Counting true and false across columns

Hiya, I want to make a new column which calculates the number of 'trues' for each opportunity across a number of other columns. The example data is below, but for some context 'service' field...

Need Help

Greg_Deckler

3 years ago

LauraCawdronDav You could do this:

Measure =
  COUNTROWS(
    FILTER(
      UNION(
        SELECTCOLUMNS('Table',"Service",[Service_A]),
        SELECTCOLUMNS('Table',"Service",[Service_B]),
        SELECTCOLUMNS('Table',"Service",[Service_C])
      ),
     [Service] = TRUE()
   )
 )

Forum Discussion

Counting true and false across columns

Related content

Total Count in Column

Counting nulls

Column count duplicates

Count base from other column

Distinctive Count across two columns