topic Re: Matrix and Measures Help in DAX Commands and Tips

Matrix and Measures Help

Anonymous — Fri, 04 Mar 2022 04:36:28 GMT

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

Re: Matrix and Measures Help

amitchandak — Fri, 04 Mar 2022 07:16:27 GMT

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.

Re: Matrix and Measures Help

Anonymous — Mon, 07 Mar 2022 00:09:14 GMT

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