topic Re: MEASURE INCORRECT? or Should I be using a Calculated Column? in DAX Commands and Tips

MEASURE INCORRECT? or Should I be using a Calculated Column?

bbass82 — Fri, 22 Nov 2024 20:39:31 GMT

Hi All,

Hope all is well. I am new to power BI and having a problem which I think is probably a simple mistake in the measure DAX calculation. I am simply trying to get the difference in dollars (risk) that I am seeing by subtracting my (Shipped dollars) - (Forecast dollars) but for some reason my totals are coming out incorrectly.

I am thinking have something to do with my column set of 'MonthYear' not being able to be recongized in my measure and thinking I need to add something into the DAX for this but not sure what part of the text string I need to change.

Here is my Matrix:

Here is my current DAX calculation for 'Unmatched Risk' (difference):

Any help getting my totals to be correct would be greatly appreciated as I really hope someone can point out what I am doing wrong and why.

Thank-you for your time,

Brandon

Re: MEASURE INCORRECT? or Should I be using a Calculated Column?

FreemanZ — Sat, 23 Nov 2024 03:08:09 GMT

hi bbass82 ,

try like:

measure =

SUM(table[ship...]) - SUM(table[Actual...])

Re: MEASURE INCORRECT? or Should I be using a Calculated Column?

Anonymous — Tue, 26 Nov 2024 06:08:05 GMT

Hi All,
Firstly FreemanZ thank you for your solution!
And bbass82 ,According to the example data created by ourselves, your formula can run normally in our test environment, if you can provide relevant example data or pbix files, it can better help you solve the problem, looking forward to your reply!

Re: MEASURE INCORRECT? or Should I be using a Calculated Column?

bbass82 — Thu, 30 Jan 2025 20:39:13 GMT

Thank-you FreemanZ, this solution worked perfectly for what was needed in my matrix. I greatly appreciate your help and apologize for the delay in response.