In Role Level Security, how do i make my dynamic header work as well.

[Odn_ndO]

I have set RLS for each region.

In my report i also have Dynamic header that will change accordingly when each reagion is selected, and if none is chose, the word GLOBAL will appear.

For this i use SELECTEDVALUE, thus with RLS, when in APAC , the header does not change and remain as GLOBAL as the slicer for region is not selected yet.

How can i make it that with RLS in place, i do not need to select the region and the correct header will reflect. but at the same time, the existing measure for the dynamic header still applies.

[lbendlin]

Consider using ISFILTERED and/or HASONEFILTER

[Odn_ndO]

Hi Ibendlin, 

Thank you for your response, my existing measures is already with ISFILTERED, kindly do see the measure as below and advise changes that has to be made.

ISSUE BREAKDOWN BY REGION =

SELECTEDVALUE

('Quarter'[Quarter],

" "

)  &

IF

(

ISFILTERED

('Region'[Region]),

""

,

" ALL"

) &

" ISSUE BREAKDOWN ANALYSIS BY REGION "

&

if

(

ISFILTERED

('Region'[Region]),

"FOR "

&

CONCATENATEX

(

values

('Region'[Region]),'Regionr'[Region],

", "

),

""

)

[lbendlin]

Formatting it gives

ISSUE BREAKDOWN BY REGION =
SELECTEDVALUE ( 'Quarter'[Quarter], " " )
    & IF ( ISFILTERED ( 'Region'[Region] ), "", " ALL" ) & " ISSUE BREAKDOWN ANALYSIS BY REGION "
    & IF (
        ISFILTERED ( 'Region'[Region] ),
        "FOR " & CONCATENATEX ( VALUES ( 'Region'[Region] ), [Region], ", " ),
        ""
    )

Be aware that you did not specify a sort order for CONCATENATEX, so the result will be random.