Chart axis from two dimension tables

[Pbiuserr]

Hello

I want maintain alike chart 

My problem is

Workers are people from DimEntity[Entity] = "Manufacturing"

Manegement are people from DimCategory[EmployeeCategory] = "Manegement" 

Executive are people from DimCategory[EmployeeCategory] = "Executive"

How to create such axis out of these two tables?

[Anonymous · Accepted solution]

Hi  @Pbiuserr ,

I created some data:

DimCategory：

DimEntity：

Here are the steps you can follow：

1. Create a table using Enter data.

Group_Table:

2. Create calculated table.

Year_Table =
DISTINCT('DimCategory'[Year])

Table =
CROSSJOIN('Year_Table','Group_Table')

3. Create measure.

Executive_Measure =
SUMX(FILTER(ALL(DimCategory),'DimCategory'[Year]=MAX('Table'[Year])&&'DimCategory'[EmployeeCategory]="Executive"),[Amount])

Manegement_Measure =
SUMX(FILTER(ALL(DimCategory),'DimCategory'[Year]=MAX('Table'[Year])&&'DimCategory'[EmployeeCategory]="Manegement"),[Amount])

Manufacturing_Measure =
SUMX(FILTER(ALL('DimEntity'),'DimEntity'[Year]=MAX('Table'[Year])&&'DimEntity'[Entity]="Manufacturing"),[Amount])

Measure =
SWITCH(
    TRUE(),
    MAX('Table'[Group])="Workers",[Manufacturing_Measure],
    MAX('Table'[Group])="Manegement",[Manegement_Measure],
    MAX('Table'[Group])="Executive",[Executive_Measure])

4. Result:

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[amitchandak]

@Pbiuserr , I doubt you can combine like that, You need to three visuals