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()
   )
 )
LauraCawdronDav's avatar
LauraCawdronDav
Icon for Helper I rankHelper I
4 years ago

Hi Greg,

 

I've tried the measure but that seems to just tell me that there are services, rather than count the number of services which is more what i'm looking for. Is that right?

 

Laura

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
4 years ago

LauraCawdronDav If you put that measure in a table visual along with Opportunity, it should return the count of the number of services in each opportunity.