Forum Discussion
Multiply Across Fact Tables with Measures
lbendlin I tried a couple of different permutations but I'm clearly not following what you're suggesting, would you mind providing a slightly more detailed explanation of what you're thinking?
Thank you,
-Robert
Super UserPlease provide sample data in usable format.
Sample PBIX and Source Data file can be downloaded from here.
Most of the terminology should match with the previous screen shot, there is a little varitation, and I simplified a couple of things. There are a couple of reference pages in the PBIX with tables on them and several relationship diagrams given there are actually three star schemas invovled.
Screen shot illustrating what I'm attempting to accomplish.
Thank you,
-Robert
- lbendlin
Why is Subcategories4 not a child dimension of Categories?
Two reasons
(1) its not always defined, particularly in the Projects Data Model, you'll note that none of those rows have a relationship to Subcategory
(2) its not actually used for any of these calculations and analysis, however the original "Benchmark" data was defined at that granular level and when the project started it wasn't clear if the end user was going to want any reporting or analysis at the Subcategory level. So the data was retained.
In the real data model, there is hierarch for Category\Subcategory, but again more as a CYA since the rest of the model, visualzation and analysis is all focused on Category, Care Setting & Site.