Column not summing totals but does when it filters

[Anonymous]

I create a measure to calculate son Mrkup values, the proble is that when I add thi to a table the rows shows the correct value but the TOTAL remain as 0

I have negative values on this column, can that be the problem?

Here is the formula 

MU$ Pending USD = IF(SUM(dlog0053ws[data.pagado]) = 0,IF(AND(SELECTEDVALUE(dlog0053ws[data.currency]) = "MXP", YEAR(SELECTEDVALUE(dlog0053ws[Order Date])) = 2022) = true, [MU$] / 20.25, IF(AND(SELECTEDVALUE(dlog0053ws[data.currency]) = "MXP", YEAR(SELECTEDVALUE(dlog0053ws[Order Date])) = 2021) = true, [MU$] / 20.47, [MU$])),0)

[v-yalanwu-msft]

Hi, @Anonymous ;

You could add another measure to ajust the total. like below:

total =
SUMX (
    SUMMARIZE (
        'dlog0053ws',
        [data.currency],
        [Order Date],
        [data.pagado],
        "1", [MU$ Pending USD]
    ),
    [1]
)

or can you share more columns screenshot associated with your DAX? 

Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.