Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
estherdom
Regular Visitor

Dynamic measure to be used on a matrix

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:

estherdom_0-1708593548512.png

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

First level:

estherdom_2-1708593726111.png

Second level:

estherdom_3-1708593760345.png

 

Any hints to achive this, will be highly appreciatted.

 

Thanks a lot!

 

 

1 ACCEPTED SOLUTION
estherdom
Regular Visitor
1 REPLY 1
estherdom
Regular Visitor

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.