IF and Summarizing not showing the totals

[nogstavo]

Hello guys,

I'm trying my best as far as my knowledge goes to solve an issue I am having:

Objective: "Sold IF" should only show the "Sold QTY" if "Value" is blank

The issue: I can seem to bring the values on a row context, but no success in summing the totals from "Sold IF".

Sold IF = 

VAR Sold_Quantities =

IF( [Value] <> BLANK(), BLANK(),
 [Sold QTY]
)

Var calculo = 

    SUMMARIZE(
        factExample,
        factExample[Data],       
        "@Totals",
        Sold_Quantities 
    )


RETURN SUMX(calculo, [@Totals])

I would gladly appreciate anyone that can help me with this.

[tamerj1]

Hi @nogstavo 

please try

Sold IF =
SUMX (
VALUES ( factExample[Data] ),
IF ( [Value] <> BLANK (), BLANK (), [Sold QTY] )
)

[nogstavo]

Thank you very much for your reply.

I've tried your syntax but it did not work, unfortunately.

The totals are still blank.

[tamerj1]

@nogstavo 
SKU column is from which table?

[nogstavo]

DimSKU is from this table:

Due to testing, I have created a many-to-many relationship, which I know is not a good practice.

[tamerj1 · Accepted solution]

@nogstavo 
Assuming [Value] and [Sold QTY] are measures then I see no reason for the following not to work

Sold IF =
SUMX (
    VALUES ( dimProductos[SKU] ),
    IF ( [Value] <> BLANK (), BLANK (), [Sold QTY] )
)

[nogstavo]

That worked, thank you very much!!!

I'll study your syntax so that I can learn more.

[wdx223_Daniel]

Sold IF =
SUMX (
    SUMMARIZE ( factExample, factExample[Data] ),
    IF ( [Value] <> BLANK (), BLANK (), [Sold QTY] )
)

[nogstavo]

Thank you very much for your reply.

I've tried your syntax but it did not work, unfortunately.

The totals are still blank.