Compare values between 2 tables, related via a lookup table

[silverdale9999]

Hello!

I have 3 tables involved here.

Incident - Contains (amongst other things) the Incident ID and Priority

Problem - Contains (amongst other things) the Problem ID and Priority

Cross Ref - Contains the Incident ID and Problem ID, and is used to relate the above two tables (Using Many to One, two way relationships).

I am trying to compare Priority from both tables, but can't figure out how to do it!

I'm trying 'Related' but when I use the following Function from the Problem table:

PriorityMatch = IF(RELATED('Incident'[Priority])=[Priority],1,0)

I get the following error:

The column 'Incident[Priority]' either doesn't exist or doesn't have a relationship to any table available in the current context.

Does 'Related' only work with directly related tables? 

Thanks 🙂

[amitchandak]

Refer two this blog how can have datediff using common table as a measure , in your case you do not have date diff you have to compare the number

https://community.powerbi.com/t5/Community-Blog/Decoding-Direct-Query-in-Power-BI-Part-2-Date-Differ...

Check this file how the data is copied to common order dim for date diff.  You can copy to you common table and match as column

https://www.dropbox.com/s/y47ah38sr157l7t/Order_delivery_date_diff.pbix?dl=0

Appreciate your Kudos.