- 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.
-
allyklee
on: Remove / Copy Visual issue - July 2025 Desktop Iss...
- stipa on: Error "[403.12–403.30] The name 'Lakehouse.Content...
-
klinejordan
on: URL is not filtering on field parameter
- MaAl 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
- zsombor on: Matrix Visual doesn't work with Field Parameters ...
-
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...
- New 8,050
- Needs Info 3,502
- Investigating 3,602
- Accepted 2,088
- Declined 38
- Delivered 3,970
-
Reports
10,248 -
Data Modeling
4,135 -
Dashboards
4,116 -
Gateways
2,116 -
Report Server
2,116 -
APIS and Embedding
1,966 -
Custom Visuals
1,790 -
Content Packs
525 -
Mobile
354 -
Need Help
11 -
Show and Tell
3 -
General Comment
2 -
Power BI Desktop
1 -
Tips and Tricks
1