Forum Discussion

LauraCawdronDav's avatar
LauraCawdronDav
Icon for Helper I rankHelper I
4 years ago
Solved

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's avatar
    Greg_Deckler
    4 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()
   )
 )
mangaus1111's avatar
mangaus1111
Icon for Solution Sage rankSolution Sage
4 years ago

Hi LauraCawdronDav ,

 

try to substitute [Service] = TRUE() with [Service] = "TRUE"

 

Please hit the thumbs up & mark it as a solution if it helps you. Thanks.