Forum Discussion
Measures not working when RLS is turned on - Join paths are expected to form a tree
Hi all I have the following error when RLS is turned on (this error does not show when RLS is off): Join paths are expected to form a tree but the table has two join paths These are th...
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.