Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
carlovsky
Helper II
Helper II

Running into a modelling issue * Need your help

Hello guys,

 

I am running into a data model issue, where it seems that I can't find any plausible solution for this.

 

Context:

Company Segment: Debt Collection Company

 

Data Model:

3 fact tables:

 

f1) reports the current amount for each case the debtor has open in our company

f2) reports the receivables from our debtors

f3) reports the agreements reached for each debtor and case.

 

Other Dimension Tables:

d1) case level

d2) debtor level

d3) date

and so on

 

Situation:

We are now conducting three distinct campaigns (email, SMS, and so on) for the cases that we have in our organization. The issue is that the incidents may appear in multiple types of campaigns.

 

Question:

I want to add a campaign name-based filter to a PBI table, to get the payments, agreements reached for the cases included in each campaign.. How is that even doable if my campaing table has no distinct values? I've tried with a bridge table, but doesn't seem to help either..

2 REPLIES 2
lbendlin
Super User
Super User

It is ok to have multiple fact tables in your data model. It is not ok to join them directly.  Instead, they should all be controlled by common dimension tables (like your campaign dimension).

 

Can't help much without seeing a sample version of your data  model.

Solved with a bridge table. Thanks

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Power BI Header Change

Power BI Header Update

Read about the exciting updates for the Power BI forum.

Top Solution Authors