Chart axis from two dimension tables

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