Forum Discussion
How to implement a star schema
Thanks for your time, I have managed to solve this issue I had.
akhaliq7 Star schemas are great but I have rarely in the real world ever seen a true star schema used in business models. They are always more complex than that. I would recommend a bridge table between your two fact tables with bi-directional relationships. Then you can add your dimensions to either fact table.
I have tried that in my case the two fact tables won't filter properly i have order_id as the key column in the bridge table but then sales person is in both fact tables but will not filter correctly in both,
unless i use sales person id as the key column in the bridge table but then order id will not be related in both tables.
akhaliq7 Going to need to see example data. Sorry, having trouble following, can you post sample data as text and expected output?
Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882
Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.sorry can't post sample data or table data fields as it is for my workplace can get in trouble for sharing internal workings, its ok if you can't help I am going to look at some other resources for getting the job done.