how to insert a calculated row into hierarchy matrix power bi

[s2888]

I already created a matrix virtual in power bi desktop. I want to insert some calculation rows (the calculation is between two categories in the hierarchy ). Is any way or feature of the power bi desktop can do? 

Thank you

[s2888]

I got the solution by adding a new column on the data mode to reform a new category column.  In this new category, you add an item you want to be one of this category. Here is the screen shot.  Red circle is the item inserted into the heriachy category. 

[Anonymous]

HI @s2888,

In fact, you can't directly modify this visual to add new types. For this scenario, you need to create a parameter table with raw table categories and new values.
Then you can use it to replace the raw matrix field and write a measure formula to use on the matrix value field to lookup row table records and calculate based on current category values.

If you are confused about these operations and coding formulas, please share some dummy data to test.

How to Get Your Question Answered Quickly 

Regards,

Xiaoxin Sheng

[s2888]

Hello Xiaoxin

Thank you for the reply.  How to create a parameter table with raw table categories and new values? Do you have screenshots or links to show me?  Also, the rows matrix is a hierarchy(5 layers hierarchy), it comes from the same field. 

Shirley

[Anonymous]

HI @s2888,

You can extract the raw table category fields and use union with row functions to add custom records to the new table.

UNION function (DAX) - DAX | Microsoft Docs

ROW function (DAX) - DAX | Microsoft Docs
Regards,

Xiaoxin Sheng

[Hariharan_R]

Hi,

can you share some screenshot? if the categories are coming from one field then you can't insert between the category values

Thanks

Hari

[s2888]

Hello, Hari

Sorry for reply you late.  Here the screenshot shows what I want to do.  However, I cannot see any feature can do this in power bi desktop 

Thank you

Shirley