Forum Discussion

maheshbabu's avatar
maheshbabu
Frequent Visitor
1 year ago
Solved

Need Urgent help-RLS, A measure is resulting correct output when slicer values selected but not RLS

Hi everyone, I am working on a finance report, where we deployed RLS to see their respective markets/verticals data.  Context: The Power BI report contains financial data, and certain measures such...
Need Help
  • SamanthaPuaXY's avatar
    SamanthaPuaXY
    1 year ago

    Hi 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 🙂

V-yubandi-msft's avatar
V-yubandi-msft
Icon for Community Support rankCommunity Support
1 year ago

Hi maheshbabu ,

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution we provided for your issue worked for you  or let us know if you need any further assistance?

Your feedback is important to us, Looking forward to your response.