Custom Column - Applying Row Level Security/Visibility Based on Criteria

[cbarker]

I have a custom column where if a certain product line is present on that row I want to code it to a different business unit and allocate values to it accordingly, otherwise I want it to reference a related function which I have that is pulling another value from another table in my query. I'm trying to publish this report to a group that I'd like to restrict visibility / access based on this 'True Region' formula below, but am uncertain how to accomplish this.

If I use row level security and apply it to the 'Region Name' from my Customer_Master table I ultimately display the wrong values that I'm trying to reallocate. Anyone have a workaround here to correctly filter this data?

My formulas are as follows;

True Region = IF(Revenue_Raw_Data[Division]="Product Line","Adjusted Region",Revenue_Raw_Data[RelatedRegion])

RelatedRegion = RELATED(Customer_Master[Region_Name])

[VijayP]

@cbarker  Try createing RLS with True Region instead of other column. it should work