Showing results for 
Search instead for 
Did you mean: 
JBaker0585 Frequent Visitor
Frequent Visitor

Show a Gross Profit % based on a User Authorization

Good Morning All,

Forum newbie here, I have a disconnected table (Cost Basis) in my Power Bi report that allows me to dynamically switch my Gross Profit % calculation between two cost structures (Comm-Cost and COGS) based on the user's selection in a slicer. This worked great when all of my user's were allowed to see either cost structure. Now, our company wants to provide access to sales associates and we need to limit these user's to only viewing one cost (Comm-Cost). I have created another table (Cost View) with the user's who we will give access and who we need to limit to only showing the one cost structure.


My slicer is setup using the below measure:

__Dynamic GP% =
VAR SelectedGP = SELECTEDVALUE ( 'Cost Basis'[Basis], "COGS" )
SelectedGP = "COGS", [__Gross Profit %],
SelectedGP = "Comm-Cost", [__Gross Profit % COMM],
[__Gross Profit %]
I have tried to modify this measure to take into account the sales associate, but I cannot seem to find the correct solution. Please let me know if you need any additional information and thanks for all of your help in advance.
@Greg_Deckler & @MattAllington  - You both have helped me a number of times with your contributions to the forum, so just in case :Data Model.PNG

Helpful resources

New Topics Started Badges Coming

New Topics Started Badges Coming

We're releasing new versions of the badge that everyone's talking about. ;) Check your inbox for notifications.

MBAS 2020

Save the new date (and location)!

Our business applications community is growing—so we needed a different venue, resulting in a new date and location. See you there!

Difinity Conference

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Solution Authors
Top Kudoed Authors (Last 30 Days)