Create relationship in semantic Model data PBI

[RajK2]

Dear Team,

I have semantic model loaded in Power BI where there is no relationship between 3 tables.

all three table are independent unable to merge it since its semantic model.

table 1                          table 2                     table 3

Product                        region                      value

apple                            US                             100

orange                          China                          59

banana                          Denmark                    40

result need in table 2 as Column  = If table 1 contain 'apple' and table 2 contain 'US' then "US Apple" else table 1

Thanks!

[Kedar_Pande]

@RajK2 

You can create a calculated column in Table 2:

Result =
IF(
CONTAINS(
'Table1',
'Table1'[Product], "apple"
) && 'Table2'[region] = "US",
"US Apple",
'Table1'[Product]
)

💡 If this helped, please give Kudos 👍 or mark it as a Solution ✅.
Best regards,
Kedar
| 🌐 Connect on LinkedIn

[RajK2]

Issue : a single value for column x in table y can be determined.