Wrong Total with IF Measure

joshua1990 — Thu, 23 Mar 2023 12:36:21 GMT

Hi experts!

I have a measure A like this:

VAR _Sales = [Sales] RETURN IF(MAX('Calendar 2'[MonthOffset]) > MAX('Calendar'[MonthOffset]), _Sales, 0)

Then I have a measure B like this:

SUM(Orders[Values])

Both measures I combine in a single measure like A + B.

But then if i put this measure into a matrix to show the values for year-month, then the total is wrong.

How would you adjust the total measure to get the totals right?

I hope this is enough information.

Thanks in advance

Re: Wrong Total with IF Measure

lbendlin — Sat, 25 Mar 2023 01:33:00 GMT