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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
Anonymous
Not applicable

Relationship between these two fact tables?

Hi,

 

ich have on one side a wager. That is my first fact_wagers. It has attributes like:

  • wager_id
  • first_product_id
  • second_product_id

 

One the other hand I have a fact for the winnings: fact_wins. This occurs later than the wager got created. 

It has attributes like:

  • wager_id
  • win_amount
  • product_id

 

The relationship between them is 1:n , because one wager could have multiple winnings, because of his first and second product. One win in the first_product is related to one row in the winnings. A win in the second_product creates another row. 

 

How would you join those facts?

Make a dim_wager_id as a degenerated dimension, because I would need that for filtering?

 

Cheers

 

 

1 ACCEPTED SOLUTION
Icey
Community Support
Community Support

Hi @Anonymous ,

 

Please check if the attachment could meet your requirements:

wager.PNG

 

There are some transformations in Power Query Editor.

 

 

Best Regards,

Icey

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

3 REPLIES 3
Icey
Community Support
Community Support

Hi @Anonymous ,

 

Please check if the attachment could meet your requirements:

wager.PNG

 

There are some transformations in Power Query Editor.

 

 

Best Regards,

Icey

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

HashamNiaz
Solution Sage
Solution Sage

Hi @Anonymous !

 

I would model this slightly different;

 

Dimesnion:
DimWager (Unique WagerID)

DimProduct (Unique ProductID)

 

Fact: (Bridging Table)

FactWagerProductWins (WagerID, ProductID, WinAmount) - Wager can have multiple ProductID, you don't need to create separate column for each ProductID

 

Relatiionships:

1 - Many between DimWager - FactWagerProductWins (based on WagerID)
1 - Many between DimProduct - FactWagerProductWins (based on ProductID)

 

This will remove the of separate FactWager (which has only WagerID & ProductID mappings)

 

Regards,

Hasham

Anonymous
Not applicable

That is interessting. In which cases you are able to design a fact_table as a dimension_table? 

 

I mean a wager is in this context a business event, which a customer produces. I never thought about to design this a dimension. Is it allowed to insert a lot of entries to a dim_table? 

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.

Top Kudoed Authors