Row level Security

[Anonymous]

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)?

[Anonymous]

@Greg_Deckler Would you be able to help with this?

[Anonymous]

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

[Anonymous]

for example

(Dax ( [Product] = "Product 1"

"cost" - 0.5))

[FarhanAhmed]

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

[NidhiBhusari]

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

[Anonymous]

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.