Forum Discussion

damguy09's avatar
damguy09
Frequent Visitor
5 years ago

Grouping / Filtering from two dimensional tables

Thank you in advance for any help.   I hope I can explain this well enough.  I have a regular star schema model and I want to create a groups for:  Strategic, Core, Opportunistic - that is based on...
tctrout's avatar
tctrout
Icon for Responsive Resident rankResponsive Resident
5 years ago

I believe the simplest way to achieve your goal on getting 2 unrleated dimensions (though they share a relationship to your fact) for unique DAX combinations would be to combine your 2 dimension tables into a sinlge master dimension table.

Its basically a cartesian product equivelant, giving you all possible combinations of the 2 dimension tables.

 

Once unified, you should be able to acheive your desired results.

damguy09's avatar
damguy09
Frequent Visitor
5 years ago

Thanks tctrout.

 

To make sure I'm understanding, create a 3rd dim table that is the concatenate of the keys of both separate dim tables and then code this new table with the new dimensional fields.  Connect this to the Fact table via the same concatenated key to give a new dimension.  

 

I can see this work but was hoping for something that might be in a measure to push through the filtering on a simplier table.