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 🙂
Hello SamanthaPuaXY , thanks for your response, would you help me in creating table?
Helper IIHi maheshbabu
This is roughly how your dimension table and fact table should look like and get linked
DimensionTb
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 RLS
When viewed under RLS, it takes sum of product A (100) divide by total of 3 products (370)
Do give a kudos if it helped 🙂