Bug when using Summarize inside SumX

Yerece — Fri, 01 Sep 2023 20:49:43 GMT

Hello,

I need to summarize a table to use it within a SUMX function. The creation of the table works as expected because I created a calculated table to check it.

DAX Var Weighted_Score = CALCULATETABLE( ADDCOLUMNS( SUMMARIZE('OpenWells Principal', 'Responsável'[Responsável], 'Intervenções'[Intervenções], 'Dados Sondas'[Casco / Capacidade]), "Nota5", [Nota Logística 5], "Proporcao", [Proporçao Un Operacional] ) )

Then I use this table in SUMX:

DAX
Var Sum_Score = SUMX(Weighted_Score, [Nota5] * [Proporcao])

What's happening strangely is that within the [Nota Logística 5] measure, there's a condition for when another measure called [Principal total OW (P50)] is equal to zero. The condition is as follows:

DAX
Nota Logística 5 = 
Var Realized = [Principal total OW (P50)]
Var Target = [Meta P50 logística]
Var Score4 = [Nota Logística 4]
Var Total_tt = [Principal total OW operações (hs)]

SWITCH(TRUE(),
Realized > 0 && Target > 0, Score4, 
Target = BLANK() && Total_tt > 0, 50,
OR(Realized = 0, Realized = BLANK()) && Total_tt > 0, 100
)

So, when I insert the virtual table into the SUMX, the condition is completely ignored. Everything is normal in the virtual table, as can be seen in the table below.

However, when this table enters as a variable within the SUMX, it cannot calculate the score when [Principal total OW (P50)] = zero. It looks like this:

Thank you all!!

Re: Bug when using Summarize inside SumX

lbendlin — Mon, 04 Sep 2023 23:44:39 GMT

Use EVALUATEANDLOG to observe the different filter contexts, the transitions, and the lineages. Then refactor your code to achieve your requirement. For development work you should avoid nesting measures inside each other, that makes it really hard to troubleshoot.

topic Re: Bug when using Summarize inside SumX in DAX Commands and Tips

Bug when using Summarize inside SumX

Re: Bug when using Summarize inside SumX