Forum Discussion
Need Urgent help-RLS, A measure is resulting correct output when slicer values selected but not RLS
Hi maheshbabu
This is roughly how your dimension table and fact table should look like and get linkedDimensionTb
FactTB:Fact_no_RLS( A simple sum to get totalvalue and does not get impacted by RLS)
I create a measure with denominator not affected by the RLSWhen viewed under RLS, it takes sum of product A (100) divide by total of 3 products (370)
Do give a kudos if it helped 🙂
Helper IIHi maheshbabu ,
This is working as per RLS is designed.
To overcome the limitation you could create a separate table such as calculating Revenue_R and unallocated values on a separate table (if they are not meant to be affected by the RLS), then in the current measure, reference the new table for the values. Do not apply the RLS or have a relationship for the new table.
Hello SamanthaPuaXY , thanks for your response, would you help me in creating table?
- SamanthaPuaXY
Hi maheshbabu
This is roughly how your dimension table and fact table should look like and get linkedDimensionTb
FactTB:Fact_no_RLS( A simple sum to get totalvalue and does not get impacted by RLS)
I create a measure with denominator not affected by the RLSWhen viewed under RLS, it takes sum of product A (100) divide by total of 3 products (370)
Do give a kudos if it helped 🙂