Formula for identify if a code client is in a table

Question

I create a new table with unique value (By SUMMMARIZE)I try to add a column that the value is 1 if [CLG_CODE] is in&nbsp;PTE[CLG_CODE], and 0 if is not presentbut there is an error (in red in the formula)Thank for your help.&nbsp;My_SMS =ADDCOLUMNS(&nbsp; &nbsp; SUMMARIZE(&nbsp; &nbsp; &nbsp; &nbsp; SMS, &nbsp; &nbsp; &nbsp; &nbsp; SMS[AGC_LIBC],&nbsp; &nbsp; &nbsp; &nbsp; SMS[CLG_CODE],&nbsp; &nbsp; &nbsp; &nbsp; SMS[CAT_LIBC],&nbsp; &nbsp; &nbsp; &nbsp; SMS[Type]&nbsp; &nbsp; ),&nbsp; &nbsp; "Code Client", SMS[CLG_CODE],&nbsp; &nbsp; "PTE", IF ( &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; CALCULATE(&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; COUNTROWS(PTE),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; PTE[CLG_CODE] = [Code Client]&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ) &gt; 0, 1, 0&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ))

lbendlin · Answer

You cannot reference a field in the same step where you define it.&nbsp; Wrap your ADDCOLUMNS in another ADDCOLUMNS.
&nbsp;
Why not use [CLG_CODE]&nbsp; directly?

Forum Discussion

Formula for identify if a code client is in a table

1 Reply

Related content

If formula

formula

DAX Formula Help

Identifying duplicates

Rolling Date Identifiers