Forum Discussion

KierenPorter's avatar
KierenPorter
Frequent Visitor
2 years ago

Always include certain rows (across multiple fact tables) based on a single (selected) condition

I am attempting a new modelling structure to negate my current method of repeating (always to be included) rows in my dataset for every "Design Option", i.e. where the red-highlighted items ar...
Need Help
KierenPorter's avatar
KierenPorter
Frequent Visitor
2 years ago

Hi V, thanks for stopping by!

 

Please find this link to a OneDrive folder holding both .pbix and .xls datasource (the latter added just incase) 

RepeatingRows

 

I'm not sure how to articulate my desires any better than:

 

any rows in any fact table (in my example file, people or items) where  "design option" column [DOID] = 0 are to be considered "always present" and subsequently ALWAYS show/sum/etc WITH results of any slicer applied to the [DOID] values.

 

...perhaps think of rows w/ [DOID]=1 as spectacles, an essential item (for someone short-sighted like me!) where rows [DOID] NOT 0 are a one-time choice of clothes? (not sure that metaphor helps! ðŸ¤£)

 

Since posting yesterday I experimented some more - and ran into another roadblock, highlighting further complication with my current method - the [DOID]=0 values are doubling up (see the donut) girls emma (18) + katie (11) should sum to 29, but are summing w/ kieren (27) to 56... when Kieren (27) is (also, and only) a boy!