Measure to check if two fields of different tables are equal

[IAM]

Hi all,

I have a SharePoint List connected to my Power BI to add changes to the original Excel file.

The field Workorders are related to eachother.

I want to know if 'Export'[Prioriteit] and Terugmelden[_Prio] are equal and show it in a table like this:

Can anyone help me with a good measure code?

[Anonymous]

Hi  @IAM ,

Here are the steps you can follow：

1. Create measure.

Measure =
var _table1=
SUMMARIZE(
    'Export', 'Export'[Workorder],'Export'[Prioriteit],"Prio",MAXX(FILTER(ALL(Table2),'Table2'[Workorder]=EARLIER('Export'[Workorder])),[Prio]))
var _tabel2=
ADDCOLUMNS(
    _table1,"Flag",IF([Prioriteit]=[Prio],1,0))
return
MAXX(
    FILTER(_tabel2,
    [Workorder] in SELECTCOLUMNS('Export',"1",[Workorder])),[Flag])

2. Result:

Best Regards,

Liu Yang

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