- Subscribe to RSS Feed
- Mark as New
- Mark as Read
- Bookmark
- Subscribe
- Printer Friendly Page
- Report Inappropriate Content
Snowflake schema vs Many to many relationship
I have created a new dimension in my model, which is based on a snowflake schema (extended star schema).
My new dimension is called kredietlimiet, and is a "satellite" dimension of the Verkooporder dimension.
So the relationships are as follows: Fact (many to one) Verkooporder (one to many) Kredietlimiet, with bidirectional crossfiltering on.
I noticed that I could not create a visual with a field from the Kredietlimiet dimension and from another dimension Klant in my example).
I could only make this work by adding a measure. Not necessarily a measure from my fact table, but just a measure:
This seemed strange to me, so I decided to make a direct relationship between my Fact and Kredietlimiet table (the key is the verkooporder ID, the same as in the above example). This relationship is a many to many relationship.
Then when I tried to do the same thing, it worked without the measure:
Why is there a difference between these same approaches? I would assume that the relationships would implicitly work the same way.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
- joakims on: "The import PowerPlatform.Dataflows matches no exp...
-
NikNithiy
on: URGENT!! Paginated Report not loading on Mozilla F...
- duarte on: Unable to sort months in PowerBI
-
mattlee on: “Add Value” in Textbox Not Visible in Dark Theme
- mattin on: Report Server Permissions Jan/May 2025
-
bhalicki
on: Bi Crashes on launch with (AS Process PID=XXXXXX H...
- stanteitelbaum on: authenticator wont trigger after purchase of new p...
-
Stinkys
on: Fix the Date function in DAX
-
Stinkys
on: Cannot login to community site
-
reubwork
on: May 25 update for Snowflake Connector v2 has broke...
- New 8,027
- Needs Info 3,502
- Investigating 3,602
- Accepted 2,088
- Declined 38
- Delivered 3,970
-
Reports
10,233 -
Data Modeling
4,131 -
Dashboards
4,114 -
Report Server
2,114 -
Gateways
2,112 -
APIS and Embedding
1,965 -
Custom Visuals
1,789 -
Content Packs
523 -
Mobile
354 -
Need Help
11 -
Show and Tell
3 -
General Comment
2 -
Tips and Tricks
1 -
Power BI Desktop
1