Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Matrix and Measures Help

All I need a little Help I have a case where I have two matrix and I want to get the difference between the two

Matrix A                                                     Matrix B

      

 

so the difference woul be 25000

I thought I would have to create a new measure in the source table that did the sum calcuations for me something like

CRD Qty = CALCULATE (
SUM ( 'Revenue-Tracker'[Qty] ),
FILTER ( ALL ( 'Revenue-Tracker'), 'Revenue-Tracker'[CRD] <= MAX ( 'Revenue-Tracker'[CRD] ) )
)
And 
FCD QTY = CALCULATE (
SUM ( 'Revenue-Tracker'[Qty] ),
FILTER ( ALL ( 'Revenue-Tracker'), 'Revenue-Tracker'[LastFCD]<= ( 'Revenue-Tracker'[LastFCD] ) )
)
The issuse I am having is when I do those two measures I don't get as the result  50000 and 75000.
I am not sure what formula I would use to basically do the math that the Matrix does.  Can any one help?   

I believe once I get those two measures correct it would just be a simple subtraction of the two measures.

Thank EVERY ONE in advance for taking a look!!

Jennifer

2 Replies