Forum Discussion

PMorfitt's avatar
PMorfitt
New Member
6 years ago
Solved

How to count a text value in multiple columns for each row

Hi All,   i have a set of data which has the following:   Products with unique identifier. Each product should have a set of documents. The data set i have has gaps with which documents are avali...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi PMorfitt ,

     

    Please create a calculated column as below.

     

    Column = IF('Table'[Conditional column.Paper]="false",1,0)+IF('Table'[Conditional column. Pen]="false",1,0)+IF('Table'[Conditional column.Shrink Wrap]="false",1,0)

     

     

     

    Best Regards,

    Jay

    Community Support Team _ Jay Wang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

VasTg's avatar
VasTg
Icon for Memorable Member rankMemorable Member
6 years ago

PMorfitt 

 

You could add a custom column to get the count of False as below

 

=Number.Abs((Number.From([Conditional column.Paper])-1)+(Number.From([Conditional column.Shrink Wrap])-1)+(Number.From([Conditional column. Pen])-1))

 

 

If it helps, mark it as a solution

Kudos are nice too

  • PMorfitt's avatar
    PMorfitt
    New Member
    6 years ago

    VasTgThank you for sharing, i've tried as you've suggested however i recieved an error message:

     

    Expression.Error: We cannot apply operator - to types Logical and Number.
    Details:
    Operator=-
    Left=FALSE
    Right=1

     

    do you mind explaining what this means and how i can adapt the formula you've provided? 

    Thanks