Trouble with Column Totals on IF Measure

[Adams_Apple]

Thanks for helping, I've dug through all the posts and tried what seems to help but I can't get my totals to work when I am using values from an IF measure.

I have a table of actual data, that the measure uses if there has been product packed in that month. If nothing has been packed, it uses Projection data from a different table.

Here is the measure:

ProductPacked = SUMX(

    VALUES('Crop Year'[Crop Year]),

    IF(SUM('Company Product'[Product Packed]) > 0,

        SUM('Company Product'[Product Packed]),

        MAX(Projections[Product Packed])))

No matter what I do, the totals only include the actual data and not the projections.

Any help is much appreciated!

[johnt75 · Accepted solution]

Try

ProductPacked =
SUMX (
    VALUES ( 'Date'[Year Month] ),
    IF (
        SUM ( 'Company Product'[Product Packed] ) > 0,
        SUM ( 'Company Product'[Product Packed] ),
        MAX ( Projections[Product Packed] )
    )
)

instead of doing the SUMX over the year column you need to do it over the year month column.

[Adams_Apple]

Thank you! that works,

is there a way I can add FILTER into that to include the CROP YEAR filter? Crop year is a text field, not a date. and it doesn't align with a traditional Jan-Dec year, so it makes my life extra interesting.

[johnt75]

Instead of 'Date'[Year Month] you can use whichever field you are using on the columns of your matrix.