Forum Discussion
Measures not working when RLS is turned on - Join paths are expected to form a tree
Will the measure work without changing the relationship used?
Otherwise, I think you need to change your model. The multiple paths are harming your functionality.
Specifically, unless there are very complex requirements, look into:
1. Separate entities into dimension tables and model as star schemas around a fact tables
2. Avoid bi-directional relationships
Hope this helps,
Nathan
I am trying to get sum of ANSAPBICustomerTransDetailed.Outstanding by ANSAPBISite. The existing active relationship will not give this info to me, as it will total by CustomerID instead. However, ANSAPBICustomerTransDetailed does contain a SiteID for each transaction, not sure I can use that in some other DAX magic way to give me an answer, without actually using the active or inactive relationship?
You could duplicate the DIM tables and have single relationships if you must absolutely use different releationships for different measures for fields you have definied to have constraints in RLS.
