Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

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 ...
DAX
RLS
  • Anonymous's avatar
    Anonymous
    4 years ago

    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.

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

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) )