Forum Discussion
Star Schema Modelling issue when using Multiple datasets
No I cant share this pbix file.
And its all sorted. I created the dimension with the ID. removed the ID from the fact table. And I kept the higher dim with just the type in it for the star schemas at the higher level of granularity.
Took a while but it was worth it and everything is working well now
Hi Debbie are you able to share a pbix file and an idea of the desired output.
What you're describing is generally called a degenerate dimension by Kimball (https://www.kimballgroup.com/data-warehouse-business-intelligence-resources/kimball-techniques/dimensional-modeling-techniques/degenerate-dimension/).
Normally you would leave it on the fact table but because you're looking to report at that level across two fact tables I think your best course of action it to pull it out as a dimension with just those id's in as you suggest. Anything else just leads to complex dax to pass the filters.
No I cant share this pbix file.
And its all sorted. I created the dimension with the ID. removed the ID from the fact table. And I kept the higher dim with just the type in it for the star schemas at the higher level of granularity.
Took a while but it was worth it and everything is working well now