Forum Discussion
How to Slice Data from Two Objects in the Data Model?
My data model contains 2 objects that contain similar but different information. I've configured slicers to filter data from the Claims object. However, I need to also ensure that the PQI Claims object is filtered by the same slicers. The DateFrom object is a DAX Calendar formula that creates a Date Dimension. The Date Dimension filters nicely both of the Claims and PQI Claims objects.
What must I do to use the same slicers to filter data from both Claims and PQI Claims objects?
3 Replies
schilders although it is not a recommended method, you can change crossfilter direction to both for one of the relationships between Claims and another table. Model relationships in Power BI Desktop - Power BI | Microsoft Learn
Thanks for the suggestion. Unfortunately, modifying the crossfilter direction did not resolve the issue. The contents of PQI Claims is acutally a subset of the Claims object. That is, not all Claims are housed in PQI claims, only those claims that meet specific criteria. I may need to re-structure my model so that I have just one Claims object rather than two?
