Return Value based on Hierarchy in Power BI

Question

Afternoon/Morning Power BI Community.&nbsp;&nbsp;I'm a new Power BI user and have a few questions around an issues that I'm running into regarding a dashboard I'm working on for my team. Here is a quick summary:I'm working on a dashboard that will enable our users to check what access level they have to a set of applications managed by the business. The way that I have the data currently setup is as follows:&nbsp;1. I'm pulling data from our Active Directory database that contains the the following values: username and acces level assigned to each user. I've name the resource Data Access Group&nbsp;2. I've created a custom table titled Data Access Level in Power BI that summarizes the data levels avaialbe (i.e base, advanced, advanced all)&nbsp;The relationship established between the two data resources is based on the Access Level. Once that has been set, I have a slicer on the dashboard that lists the name of the users that have access to the application in reference. The slicer is pulling the names from the Data Access Group resources. When a name is selected on the slicer, I have a table that highliest the Data Access Level the user has. For instance, if I select James Smith on the slicer, the table highlights what level access James Smith has (base, advanced, etc). Here is the DAX code I'm using to complete this:&nbsp;&nbsp;Highlight w Slicer = VAR SelectedDisplayNames = SELECTEDVALUE( 'Group Display Name'[group.member.displayName] )RETURNCALCULATE(DISTINCTCOUNTNOBLANK( 'group'[group.member.displayName] ), FILTER( 'group', 'group'[group.member.displayName] = SelectedDisplayNames ) )&nbsp;The issue that I am running into is that, a user can have multiple access level...James Smith can have both base and advanced level access. What I would like to do is have it setup so that the highlighted level returns the highest level access - so if James Smith has both base and advanced, I want the table to only highlight the advanced level access James Smith has. I know to accomplish this I need to setup a hierarchy but not sure the best way to approach that....Is there a way to filter the original data to only return the highest level??&nbsp;&nbsp;&nbsp;

edhans · Answer

How to get good help fast. Help us help you.

How To Ask A Technical Question If you Really Want An Answer

How to Get Your Question Answered Quickly - Give us a good and concise explanation
How to provide sample data in the Power BI Forum - Provide data in a table format per the link, or share an Excel/CSV file via OneDrive, Dropbox, etc.. Provide expected output using a screenshot of Excel or other image. Do not provide a screenshot of the source data. I cannot paste an image into Power BI tables.

datboioscarr · Answer

edhans&nbsp;thanks! I've gone ahead and revised my original question. I hope that provides more context. Not able to share a sample as the data is sensative.&nbsp;

edhans · Answer

Understood. But you are asking me to create fake data to mimic data I haven't seen to make a measure work.&nbsp;

Forum Discussion

Return Value based on Hierarchy in Power BI

3 Replies

Related content

Measure returning incorrect value

Date Different return wrong value

Date hierarchy

MAXX Returning duplicate values

Return "Specific value" from table 1, if not found, return value from table 2