Matrix and Measures Help

[Anonymous]

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

[amitchandak]

@Anonymous , what is LastFCD and CRD are giving, if those are dates, they should join with commom date table and then you should measure use userelationship and then take a diff

https://radacad.com/userelationship-or-role-playing-dimension-dealing-with-inactive-relationships-in-power-bi

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

[Anonymous]

LastFCD and CRD are dates and they are just normal MM/DD/YYYY format dates throughout the year

Please let me know if this helps.

Thanks

Jennifer