Combine matrix and table

[Anonymous]

I have a matrix with a project hierarchy in one column, but is it possible to also show parametres in a second column?

The data looks like this:

Project Lvl 1	Project Lvl 2	Produkt Name	Project Costs
PROJECT000000: Administration	PROJECT000000_02: Admin	Construction	11343
PROJECT000001: Concrete	PROJECT000001_01: Hours	Rig	10819
PROJECT000001: Concrete	PROJECT000001_02: Admin	Rig	16668
PROJECT000002: Steel	PROJECT000002_01: Hours	Construction	916
PROJECT000002: Steel	PROJECT000002_02: Admin	Construction	3206
PROJECT000003: Wood work	PROJECT000003_01: Hours	Construction	18688
PROJECT000003: Wood work	PROJECT000003_02: Admin	Construction	55476
PROJECT000003: Wood work	PROJECT000003_03: Material	Rig	688031

and i would like to display it like this, with the steped hierarchy in one d

[Anonymous]

@MFelix 

Another problem occured, because I do not have access to create new columns in the dataset.

Is there a DAX-formula that can do the same trick?

[MFelix · Accepted solution]

Hi @Anonymous ,

To what I can see from the image you provide you want to have an additional row in the headers but the value in the values.

Add a column with blank values to your model then just put your matrix in the following setup:

• Rows:
  • ProjectsLevel1
  • ProjctsLevel2
  • BlankColumn
• Values
  • FirstProduct Name
  • Sum ProjectCosts
• Turn off subtotals

Result below:

[Anonymous]

@MFelix  only on eissue. When I click on the + sign on the lowest level I get this error.

Do you know how I can work around this? The model is simple with everything in the same table, just used for this example.

[MFelix]

Hi @Anonymous ,

On the lowest level as you can see from my visualization there is no + sign, can you tell me what are the columns you are using for the hierarchy on row level.

[Anonymous]

@MFelix 

Report:

Visual:

 

Data:

[MFelix]

Hi @Anonymous ,

I have the exact same setup and everything is working properly, except when I do one thing that is to have the blank value from another table that will return the same error you data should look like this:

As you can see I have the blank column in the same table that will work properly.

[Anonymous]

@MFelix Thanks 🙂

[Anonymous]

@MFelix  Thank you! That turned out perfectly 🙂