Forum Discussion
Solved
Data Modeling: Dimension Table with Component from Another Dimension
I'm in the process of trying to transform a semi-relational data model into a star schema for PowerBI and have been stumped by a situation where one dimension is a component of another. The two di...
You may take a look at the links below.
- https://community.powerbi.com/t5/Desktop/composite-primary-key/td-p/307604
- https://www.sqlbi.com/articles/physical-and-virtual-relationships-in-dax/
Duplicating the Date dimension does allow another relationship, but that would require two selections to be made when slicing by date. From the user experience side, I need for a single selection on the Date dimension to have the effect of filtering both.
Here is an image of the sample model. I can share the toy pbix, too, but I cannot find a way to attach files here.
You may take a look at the links below.
- https://community.powerbi.com/t5/Desktop/composite-primary-key/td-p/307604
- https://www.sqlbi.com/articles/physical-and-virtual-relationships-in-dax/