January 13, 2016 at 7:14 pm
I have a healthcare model, where an episode has 1 to many diagnosis. I have used the Kimball bridge table to model the data (http://www.kimballgroup.com/2012/02/design-tip-142-building-bridges/). I have created a SSAS tabular model and created relationships between the episodes table the bridging tables (see attached).
When I analyse the data in excel, and filter on diagnosis from the diagnosis table, it does not correctly filter the episode measures. (see attached). From what I've read, it seems the filter context is not passed through the relationship.
Does anyone know how to get his working? I just want to be able to filter a list of episodes based on their diagnosis.
January 14, 2016 at 6:55 am
SSAS Tabular does not support many-to-many relationships natively. You'll need to write DAX. The most concise, easy to understnad article I have found on this topic is: https://www.sqlbi.com/articles/optimize-many-to-many-calculation-in-dax-with-summarize-and-cross-table-filtering/.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply