Forum Discussion
Dynamic RLS in One to many relationship
Hello BI folks , I have three different tables A, B and C And there's both sided many-to-one relationships. C Many to one -> A -> One to many B (Here i defined as bidirectional and enabled sec...
1. Create a new measure in Table C that counts the number of related rows in Table B for each row in Table C. You can use the RELATEDTABLE function to get a reference to Table B and the COUNTROWS function to count the number of related rows.
B Count = COUNTROWS(RELATEDTABLE(B))