Matrix with 2 columns

[Dimitris_Kats]

Hello dear members.

I am trying to add 2 columns on a matrix table but it doesn't seem possible.

The desire result is the following:
                                 IT                                HR                           SALES
                 INTERNAL EXTERNAL INTERNAL EXTERNAL INTERNAL EXTERNAL
Company1       11                5                12                1               2             4 
Company2       14               0                   9                1               3             5
Company3       13               1                   8                1              2              4

Thank you in advance for your time

[Dimitris_Kats · Accepted solution]

Hello there.

I realized that I just had do to 2 measures:
Calculate(sum(table1[Headcount]), table1[Category] = "INTERNAL")
Calculate(sum(table1[Headcount]), table1[Category] = "EXTERNAL")

That's it hehe.

Thank you again

[Anonymous]

Hi @Dimitris_Kats,

Can you please share a pbix or some dummy data that keep raw data structure with expected results? It should help us clarify your scenario and test to coding formula.

How to Get Your Question Answered Quickly  

Regards,

Xiaoxin Sheng

[croberts21]

As far as PBI would see it, you have 7 columns in this matrix in your post. So your question is confusing. Which columns exist before adding the 2 columns? Which 2 columns do you want to add?

Can you post a link to a simplified spreadsheet with test data for us to work with?