Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! It's time to submit your entry. Live now!

0

Data model issue

Submitted by Anonymous on ‎11-17-2022 06:37 AM

Hi All,

 

We have multiple fact tables in the model (In this pic , i have shown only 2 fact table) and 10 dimension tables.
All the Dimension & fact tables are SCD type 2 and we need to do point in time reporting. In one of the matrix visualization we need to show data from DIM1 & FACT2 and we do not want to enable Bi-directional as its not recommended. Initially our data model was having many to many relationship and to avoid that we created this factless fact for each fact table as the granularity of the fact tables are different. Please suggest an approach to avoid bidirectional & complex DAX queries on the report, as we are giving this report to the end-user for self service visualization.

IDM_0-1668695805672.png

 

Awaiting your response

Status: Delivered
See more ideas labeled with:
1 Comment (1 New)
Comments
Anonymous
Not applicable
‎11-18-2022 12:03 AM

Hi @Anonymous ,

 

Usually, when dealing with many-to-many relationships, we recommend that users use bridge tables to optimize the model.It's a way to create a many-to-many join by creating a table with a column that contains a singular instance of each unique value, which creates a bridge to join two or more many columns together.

 

How to Join Many to Many with a Bridge Table in Power BI | Seer Interactive

 

Best Regards,
Community Support Team _ Caitlyn

Idea Statuses