Forum Discussion
Calculate in calculated Column
I am trying to find out how many calls that I have got with in the last 3 days with the name of same account number. For that I choose to create a caluculated column which finds the number of calls w...
I made mofications and finally I made this to work by using the below formula...
=
VAR DT = call_details[SHORT_START_DT]
RETURN
CALCULATE (
DISTINCTCOUNT ( call_details[CALL_ID] ),
ALLEXCEPT ( call_details, call_details[FINAL_ACCT_ID] ),
call_details[SHORT_START_DT] < DT
&& call_details[SHORT_START_DT]
>= DT - 3
)
The above formual is returning a Circular Dependecny error. I know the Outer CALCULATE function has to perform a context transistion for every row and that's going to be costly. I am performing this on 14M rows. Can I acheive in any other way with out using outer CALCULATE function. Thanks for the help.
I made mofications and finally I made this to work by using the below formula...
=
VAR DT = call_details[SHORT_START_DT]
RETURN
CALCULATE (
DISTINCTCOUNT ( call_details[CALL_ID] ),
ALLEXCEPT ( call_details, call_details[FINAL_ACCT_ID] ),
call_details[SHORT_START_DT] < DT
&& call_details[SHORT_START_DT]
>= DT - 3
)