Forum Discussion
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>...
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 ))RETURNIF ( ISBLANK ( _C ), 0, _C )
Then use this
=if('Table1'[TITLE]=0,"Yes","No")
Again, unfortunately not.
May be worth adding that not every customer that rang in (had a CLI) would have an SMS sent to them, likewise not every customer who had an SMS sent to them would have called in (CLI)
Can you document your criteria for Yes or No? Above formula will give result as per data set and result posted by you.
If you can post data where the formula is not giving the result and the reason for that, then right formula can be made.
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 ))RETURNIF ( ISBLANK ( _C ), 0, _C )