Need help with single calculation which can show numbers from different columns depends on access.

[RolinMartis]

Hi Team,

I need to create a single calculation which can show numbers from different columns depends on access.

access is restricted at T1 Org level. when a user with T1 Org level access views he will be able to see targets for only his Org

when someone with Global access visits, he should be able to view overall targets 

so every org will have a % target number at band level and for overall there is different target. Its not sum of all orgs.

so my data looks like below now. Target column is for each org and Overal Target is the number for whole Org so you will see same numbers across org for a band

I need to build a chart to show HC actual vs Target. so it should look like below

For China Geo T1:

For CNBU T1

For overall

I have built the data  based on this required, Ill be happy to change the Template.

Please help me with this requirement

[Greg_Deckler]

@RolinMartis You need to implement Row Level Security (RLS). Row-level security (RLS) with Power BI - Power BI | Microsoft Docs

[RolinMartis]

@Greg_Deckler 

HI Greg,

I do have ROW level security enabled.

But my requirement is to build a chart which will show different columns for each roles.

I have 2 different columns in my data and the chart should show numbers from 1 columns when someone from a specific role views and then same chart should pick another column when someone with global access views the chart.

Is is doable?

Regards,

Rolin