cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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" )
RETURN
SWITCH ( TRUE (),
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

Announcements
New Kudos Received Badges Coming

New Kudos Received Badges Coming

Kudos to you if you earned one of these! Check your inbox for a notification.

Microsoft Implementation for Communities Wins Award

Microsoft Implementation for Communities Wins Award

Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Kudoed Authors (Last 30 Days)
Users online (2,569)