cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
dpjan Frequent Visitor
Frequent Visitor

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

Accepted Solutions
Super User
Super User

Re: Matrix comparison of calculated measures

Hi,

 

You may download my PBI file from here.

 

Hope this helps.

 

Untitled.png

5 REPLIES 5
Highlighted
Super User
Super User

Re: Matrix comparison of calculated measures

Hi @dpjan ,

 

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!  

dpjan Frequent Visitor
Frequent Visitor

Re: Matrix comparison of calculated measures

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

Super User
Super User

Re: Matrix comparison of calculated measures

Hi,

 

You may download my PBI file from here.

 

Hope this helps.

 

Untitled.png

dpjan Frequent Visitor
Frequent Visitor

Re: Matrix comparison of calculated measures

Thank you @Ashish_Mathur !!

Super User
Super User

Re: Matrix comparison of calculated measures

You are welcome.