Forum Discussion

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>...

Most Valuable Professional

4 years ago

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.

Frequent Visitor

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 )