Dynamic RLS not working in Datamarts as well as not being able to SUM decimal values

Hi,

So the relationships mentioned above.
The Users table contains people's email address:
 UPN
[email protected]
[email protected]

The Locations table then contains the Location Keys as well as the email address of people who can access them. For example:
Location Key                UPN
        1              [email protected]
        1              [email protected]


Then finally Locations contains all the individual Location Keys:
Location Key
         1
         2
         3

In the above scenario both of us should only be able to view Location data for Location Key 1.