Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

ignore RLS for a aggregated measure

HI    I HAVE A PBIX FILE I CAN SEND TO YOU IF YOU WANT A TEMPLATE    I have a aggreate  sum measure that dosent work as entented after i apply RLS Sales amount= sum(sales)   before RLS is appl...
Need Help
AilleryO's avatar
AilleryO
Icon for Memorable Member rankMemorable Member
4 years ago

Hi,

 

Could it be possible to make a pre-consolidated table of your data ?

If you create a calculated table with your consolidated calculations it should not be affected by RLS.

Do not hesitate it this is not clear enough.

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    do you mean to merge the two tables or to use the function calculatetable?

    • AilleryO's avatar
      AilleryO
      Icon for Memorable Member rankMemorable Member
      4 years ago

      I was thinking of CALCULATETABLE. That's what I did in a project to keep the display of the percentage of different region, even when RLS was applied to a region.

      The RLS should not affect the calcultation of your calculatedtable.

      • Anonymous's avatar
        Anonymous
        Not applicable
        4 years ago

        do you have a sample of the code. I will for sure look into the function and try to solve my problem with calculatetable