Driving a characteristic from 2 different supporting tables

[LucaA]

Hi All,

i have a characteristic based on the client ID (so i have it in the "client master data" table) which for a specific plant has to be related not to the Client but to the "Plant Name".

So to solve the first step i created a relationship between client master data table and the "Sales" FactTable.

How i can manage (using only connections and not calculated columns on fact table) the exception related to the plant

thanks for the support

Luca

[amitchandak]

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

[LucaA]

The idea is that i have to carry "SubSegment" info from Client Master Data to Sales DB using CLient ID field. However for some lines of the sales DB that characteristic is not based on CLient ID but on another field. I am wondering if and how i can manage it only using connections and not adding an "if rule" in the fact table.

thanks

Luca

[v-yiruan-msft]

Hi @LucaA ,

Please review the content in the following links, hope they can help you.

Joining Tables on 2 Columns in Power BI

composite primary key

Best Regards