Total in matrix column is zero

[Anonymous]

Hi all,

I have a matrix where I want to show Sales values and the Total, but the Total is blank.

The measure is: 

SumSalesLegal = IF([Confirmed Order] = 1,CALCULATE(SUM(Query2[Amount]),FILTER(Kontoplan,Kontoplan[Account Number] = 1510))*1,0)

The table works before I add "IF([Confirmed Order] = 1" it doesnt sum correct.

Tried to search for a solution, but cant find any proper. 

[Anonymous]

I believe it's because it's lacking of row level iteration. We need build it up using SUMX. Alternatively, we could add a calculated column as opposed to a measure.

I encountered the same issue today; got resolved by either way.

[tamerj1 · Accepted solution]

Hi @Anonymous 

what are you slicing by in this table/matrix visual? Let's assume each row in this table/matrix visual represents a product then 

SumSalesLegal =
SUMX (
    VALUES ( 'Product'[Product Name] ),
    CALCULATE (
        IF (
            [Confirmed Order] = 1,
            CALCULATE (
                SUM ( Query2[Amount] ),
                FILTER ( Kontoplan, Kontoplan[Account Number] = 1510 )
            ) * 1,
            0
        )
    )
)

[Anonymous]

Hi! I modified the product and it worked! Thanks! Can you help me understand how it is working?