Dynamic measure to be used on a matrix

[estherdom]

Hello,

I would like to create a dynamic measure to be used on matrix with different hierarchies.

My main table shows order lines and for each order line I have several information like vendor and team. Then I have two measures one called Target Team and another called Target Vendor (they are not correlated).

I would like to create a measure called Target to combine both Target Team and Target Vendor. So in case I create a materix with first hierarchy showing summary per team I can see target team and in case I go one level down on same materix I see Vendor and it will show me Target Vendor.

Example of main table:

Example of result I would like to see on a matrix:

First level:

Second level:

Any hints to achive this, will be highly appreciatted.

Thanks a lot!

[estherdom · Accepted solution]

I found the answer in this post:

Solved: Dynamically Calculated Values Depending on Hierarc... - Microsoft Fabric Community