Comparison of tables

[Anonymous]

Hi, 

I would like to compare the data between two tables. I would like to calculate in a FULL table (code price list) how many times I find the value of the table (code boff). I am interested in knowing for each row of the "code price list" table if it has found the correspondence in the "code boff" table.
Here is an example:

This is the result:

Have you some solutions ? 

Bal

[Anonymous]

Thanks but that's not what I'm looking for. Maybe I was unclear. My purpose is to create a matrix with the "code price list" column in which I look for the values ​​of the "code boff" column

[v-xicai]

Hi @Anonymous ,

You can create measure Matched code boff using LOOKUPVALUE.

Matched code boff= LOOKUPVALUE('code boff'[Code2],'code boff'[Code2],MAX('code price list'[Code1]))

Best Regards,

Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[v-xicai]

Hi @Anonymous ，

You can create measure Count time to calculate how many matched rows between the two tables.

Count time =

VAR _table=SUMMARIZE('code price list','code price list'[Code1],"d",IF(MAX('code price list'[Code1])=MAX('code boff'[Code2]),1,0))

RETURN SUMX(_table,[d])

 

Here is my test pbix: https://qiuyunus-my.sharepoint.com/:u:/g/personal/pbipro_qiuyunus_onmicrosoft_com/EfU3dEzwU8BCpMEJXccGmYsB9Lr9YKD5VACTKruSgB0QBw?e=eoiIUS

Best Regards,

Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[parry2k]

@Anonymous try followning measure, change table and column name as per your dataset

Found = 
VAR t = INTERSECT( ALL( TableCodeBuff ), VALUES( TableCode[Code] ) )
RETURN COUNTROWS( t ) + 0