slicer not refresh ---- RLS

[santiagomur]

Hi , 

i have some problems with the slicer is not refreshing when the rsl changes. 

i have a table with the user name and a RLS  formula User = UserName()

Example

table 1                                           

User

A

B

C

Table 2

User	Name	Age
A	Jhon	10
A	Peter	20
A	Erik	30
B	Frank	40
C	Nichols	50

step 1 

step 2 

show as RLS user "A" the filter row is working, but i don't want to see a sum on the age card.

step 3 

I select "Erik" and then select to show as RLS user "A", and is perfect only show the names for user "A" the age card is not sum. 

step 4 

with Erik still selected change the RLS to user "B"  now the slicer show me Erik and frank, but Erik is not a name from user "B" what i want its the slicer refresh and only show me Frank.

i know the problem is that i publish with Erick selected but if i publish without, all the visual show sums, and i don't know how to publish without selection and the visuals show the data for the first row available.

( i try do the same with a chicletslicer with forced selection apply and works, when i change the RSL the slicer refresh their values) but my boss what to use the default visuals. 
 

[v-chuncz-msft · Accepted solution]

@santiagomur 

You may try adding the following measure.

Measure =
CALCULATE (
    SUM ( 'Table 2'[Age] ),
    TOPN ( 1, 'Table 2', 'Table 2'[Name], ASC )
)