Measure to check if two fields of different tables are equal

IAM — Tue, 11 Apr 2023 11:45:11 GMT

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?

Re: Measure to check if two fields of different tables are equal

Anonymous — Thu, 13 Apr 2023 07:30:50 GMT

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

topic Re: Measure to check if two fields of different tables are equal in DAX Commands and Tips

Measure to check if two fields of different tables are equal

Re: Measure to check if two fields of different tables are equal