Forum Discussion
RLS Changing the Count Measure Value
Hello, I have a report which brings data from tables merged together as 1 using INNER JOIN. The main table is - SiteMembership I need to Count the SiteMapId from SiteMembership ...
amitchandak Thanks, I resolved it myself. The issue was that the bridge table for dynamic RLS was not created and hence it was directly applying the filters on the main table.
Anonymous ,what should happen with RLS.
I think you should use a measure like
Client Count =
VAR V1 = CALCULATE(COUNT(SiteMembership[SiteMapID]),filter(SiteMembership, SiteMembership[GroupID]=2) )