topic Re: IF and Summarizing not showing the totals in DAX Commands and Tips

IF and Summarizing not showing the totals

nogstavo — Wed, 15 Feb 2023 23:17:22 GMT

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.

Re: IF and Summarizing not showing the totals

wdx223_Daniel — Thu, 16 Feb 2023 03:14:52 GMT

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

Re: IF and Summarizing not showing the totals

tamerj1 — Thu, 16 Feb 2023 03:36:46 GMT

Hi nogstavo

please try

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

Re: IF and Summarizing not showing the totals

nogstavo — Thu, 16 Feb 2023 11:09:51 GMT

Thank you very much for your reply.

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

The totals are still blank.

Re: IF and Summarizing not showing the totals

nogstavo — Thu, 16 Feb 2023 11:10:10 GMT

Thank you very much for your reply.

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

The totals are still blank.

Re: IF and Summarizing not showing the totals

tamerj1 — Thu, 16 Feb 2023 11:22:56 GMT

nogstavo
SKU column is from which table?

Re: IF and Summarizing not showing the totals

nogstavo — Thu, 16 Feb 2023 11:30:02 GMT

DimSKU is from this table:

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

Re: IF and Summarizing not showing the totals

tamerj1 — Thu, 16 Feb 2023 11:36:31 GMT

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] ) )

Re: IF and Summarizing not showing the totals

nogstavo — Thu, 16 Feb 2023 11:42:00 GMT

That worked, thank you very much!!!

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