Single Selection of aggregated columns

[AMBP1973]

Hello,

I am seeking a solution for the following:

I have created the following Dax to aggregate 3 columns into one to aggregate 'positions assigned against roles for a particular task:

Content Manage. Roles Aggr = 'DI Review'[Content Author] & "-" & 'DI Review'[Content Manager] & "-" & 'DI Review'[Approver]

Context

Essentially, all three columns have the same attributes (positions) against a particular role (Content Author, Content Manager, Approver); in this case the 'role' is the column title i.e. 

Each row in the dataset is repesented as a task, and against that task are three 'roles' required to complete the task. For any particular task a 'position' can be assigned 1 or all of those roles for that individual task. Example of data from spreadsheet below:

Solution Required:

I would like to show how many tasks by position, but have the role/s defined in the chart also, and if possible ensure the 'total' numbers are a distinct number against the tasks and not a reflection of how many roles a 'position' has across all tasks.

Here is a chart I started with

I would also like a slicer that enables selection of a single position to filter by. At the moment it only gives me the below

 Hopefully this makes sense. Unfortunately, I cannot share the data.

Any assistance would be much appreciated 🙂

[xifeng_L]

Hi @AMBP1973 

You can use PowerQuery to convert the table structure into the structure shown in the following figure.

Then, create the measure and bar chart as below: 

Did I answer your question? If yes, pls mark my post as a solution and appreciate your Kudos !

Thank you~