Forum Discussion
is a temp table-like function possible?
Hi Folks I'm working with a large medical claims file in a Tabular data model in Connect Live mode and am looking for a way to get ALL claims for individuals who have ever had a particular proced...
Hi jim_lucht
The structure of what you are wanting to do is basically Basket Analysis:
http://www.daxpatterns.com/basket-analysis/
If you want to calculate specific measures filtered to claims for those individuals who have ever had a particular procedure, you could use the pattern on that page with a 'Filter Procedure' table with inactive relationship.
Possibly another approach would be to have a PersonID-Procedure bridge table, related to your PersonID column with a bidirectional relationship - haven't tried that before myself.
Cheers,
Owen
