Compare entries in two tables

[bpn1973]

Hello!

I'm trying to comapre bases from two accounting systems (tables). Both tables should have same entries for each SKU code (the entries, that should match are marked with red). Unique SKU codes are in separate table. 

I created a simple measure that should've done the trick

Compare Groups = SELECTEDVALUE(UIS_ID_GOODS[Группа аналитического учета])=SELECTEDVALUE(NRS_ID_STRETCH[Группа аналитического учета])

The idea was for it return true or false.

And results returned by it are both wrong 😞 No Slicers or Filters applied.

I'm sure its a mistake on my part in the measure

Thank you!

[amitchandak]

@bpn1973 , selectedvalues means they are coming from slicer ? one way is to move data from one table to another

https://www.youtube.com/watch?v=czNHt7UXIe8

Then we can do this in measure too. 

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

[bpn1973 · Accepted solution]

Amitchandak, thank you for your reply. While making a sample pbix found a workaround for my problem.

Compare =
VAR NRS_VALUES =
SELECTEDVALUE ( NRS_ID[NRS SKU Group] )
VAR UIS_VALUES =
SELECTEDVALUE ( UIS_ID[UIS SKU Group] )
VAR RESULT =
IF ( NRS_VALUES <> UIS_VALUES, "FIX IT" )
RETURN
RESULT

Added two more measures with SELECTEDVALUE just to check if it displays the right thing.