- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Driving a characteristic from 2 different supporting tables
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Hi @LucaA ,
Please review the content in the following links, hope they can help you.
Joining Tables on 2 Columns in Power BI
Best Regards
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources
Join us at the Microsoft Fabric Community Conference
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Power BI Monthly Update - February 2025
Check out the February 2025 Power BI update to learn about new features.

Subject | Author | Posted | |
---|---|---|---|
07-03-2024 03:10 AM | |||
08-26-2024 08:55 PM | |||
07-04-2024 04:53 AM | |||
08-05-2024 04:55 AM | |||
06-24-2024 09:04 AM |
User | Count |
---|---|
87 | |
81 | |
53 | |
38 | |
35 |