See if field code match in other table

[cristian_av]

Hi

I have two tables that are not related.

I need to see in a Simple Table, for each row, how many codes are possible in match in the other table.

Tables are not related in the data model. (And it's really hard to make them related, as I din't make the model)

So far, I've tried with the following expressions. None of this worked:

=Count({<CurvaVariedad={"$(=VariedadRealCodigo)"} >}CurvaVariedad)

 =Count({<CurvaVariedad={"$(=Max(Aggr(Max(VariedadRealCodigo),VariedadRealCodigo,[Variedad Real])))"} >}CurvaVariedad)

Table 1:

Table 2:

Thanks!

[neelamsaroha157]

Try this - 

Count({<CurvaVariedad={$(=chr(39) & If(GetPossibleCount(VariedadRealCodigo)>0, Concat(DISTINCT VariedadRealCodigo,chr(39)&','&chr(39))) & chr(39))} >}CurvaVariedad)

[cristian_av]

Set analysis don't work for dimension values. But instead, I used an If that is slower, but works.
Sum(if(VariedadRealCodigo=CurvaVariedad,1,0) )>0,1,0