Forum Discussion

ImageZ's avatar
ImageZ
Frequent Visitor
4 years ago
Solved

Counting Values from another column

Hey (first post here so I'll try to be thorough) - an example of my table below.   ID      TITLE        CLI           Campaign     Call Reason 1        111          <null>     New sale      <null>...
Need Help
  • ImageZ's avatar
    ImageZ
    4 years ago

    hey,

     

    think ive managed to fix it from using a very old thread using the below - seems to do the trick

     

    Callback on SMS =
    VAR _B =
    FIRSTNONBLANK ( Call_List[TITLE], "" )
    VAR _C =
    CALCULATE (
    COUNTROWS ( 'Call_List' ),
    FILTER ( ALL ( 'Call_List' ), 'Call_List'[CLI] = _B )
    )
    RETURN
    IF ( ISBLANK ( _C ), 0, _C )
Vijay_A_Verma's avatar
Vijay_A_Verma
Most Valuable Professional
4 years ago

Use below formula in a Calculated column

=if('Table'[TITLE]='Table'[CLI],"Yes","No")
Replace Table with your table name.

  • ImageZ's avatar
    ImageZ
    Frequent Visitor
    4 years ago

    Hey,

     

    Unfortunately this wouldnt work as each row is individual, if it has a number in the TITLE it has a null CLI and vice versa