Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Row level Security

Hi, so i'm trying to implement RLS however, I've been asked to create something where it presents the data differently. 

so for instance I have a sales report however, I am showing certain products to certain people, however, when that RLS is applied I also want the data to be manipulated. Is that possible?

 

If i have £100 for the general report for all products but £50 for product 1 automatically, can it be changed to show more or less (£45/£55)?

Data Protection
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests

6 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    for example

    (Dax ( [Product] = "Product 1"

    "cost" - 0.5))

    • NidhiBhusari's avatar
      NidhiBhusari
      Helper IV
      5 years ago

      Hi Anonymous can you please elaborate more on which basis you want the data to change dynamically on applying RLS?

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        5 years ago

        Yes so I want the data to change depending on what user can view it.

        So if i have a manager they can see everything. But if I have a sales person I'd like them to see the cost - a certain amount. 

    • FarhanAhmed's avatar
      FarhanAhmed
      Community Champion
      5 years ago

      You should maintain the Percentage List (Cost) in the Product Dimension that will be used to calculate the values/measure of your product.

       

       

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Or is there a way for me to change this formula 

    Var Wapf =
    DIVIDE ( [IEA*PROFIT MARGIN], SUM ( 'Detail'[IEA] ) )
    Return
    if(ISBLANK (WAPF), BLANK (), WAPF + 0.5)
     
    so that it is only for the general report when no filters are applied or RLS but when RLS is applied there is no Return