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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

Matrix comparison of calculated measures

Hi there

 

I have 2 tables (Actual & Target) setup per below, both of which has a measure that divides cost by units:

 

Table Actual    
ProductMonthStatusCostUnitsMeasure - Cost per Unit
AJanOld1001010
AJanNew4002020
BJanOld2001020
BJanNew5002025

 

Table Target    
ProductMonthStatusCostUnitsMeasure - Cost per Unit
AJanOld80108
AJanNew3002015
BJanOld1501015
BJanNew5002025

 

How do i setup a relationship which allows for below Matrix visualization (comparison of Cost per unit) to be correctly shown.

 

Currently I have a relationship by Product but the result Matrix visualization shows the same values under Columns Old / Target & New / Target.

 

Many thanks!

 

Matrix Visualization Comparing Measures - Cost per Unit (For January)
      
StatusOld New
ProductActualTargetActualTarget 
A1082015 
B20152525 
1 ACCEPTED SOLUTION
Ashish_Mathur
Super User
Super User

Hi,

 

You may download my PBI file from here.

 

Hope this helps.

 

Untitled.png


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

View solution in original post

5 REPLIES 5
Ashish_Mathur
Super User
Super User

Hi,

 

You may download my PBI file from here.

 

Hope this helps.

 

Untitled.png


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
Anonymous
Not applicable

Thank you @Ashish_Mathur !!

You are welcome.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
LivioLanzo
Solution Sage
Solution Sage

Hi @Anonymous ,

 

you would need to create a 'Product' dimension and relate it to both the target table and the actual table (one to many relationship) and afterwards use the 'Product' column from the Product table in the matrix rows.

 


 


Did I answer your question correctly? Mark my answer as a solution!


Proud to be a Datanaut!  

Anonymous
Not applicable

Thanks @LivioLanzo for the reply!

 

May I know what columns need to be in the 'Product' table ? I have setup a table with Product A & B (as below) and linked this to actual & target table but still matrix is not showing the correct result.

 

Product table

Product Table.JPG

 

Relationship

Relationship.JPG

 

Matrix outcome

Matrix.JPG

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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