topic Matrix not returning the correct Total Amount in DAX Commands and Tips

Matrix not returning the correct Total Amount

Anonymous — Fri, 24 Jan 2020 12:25:57 GMT

Hello,

I would like to build a matrix that would return the correct total amount.

The rows on this matrix are pre-defined by an auxiliary table (since I want want them to follow that Order).

The auxiliary table that looks like the following:

Measure Index

And a measure is the following:

Table_Measures = SWITCH(

LASTNONBLANK(Aux[Measure],1),

"Measure 1",10,

"Measure 2",20,

"Measure 3",5,

"Measure 4",5,

"")

I would like my Matrix to return the correct total (40), and instead returns amount 5:

Any help would be much appreciated. 🙂

Anonymous — Fri, 24 Jan 2020 13:48:56 GMT

Try something like

Total=

var Table_Measures = SWITCH(

LASTNONBLANK(Aux[Measure],1),

"Measure 1",10,

"Measure 2",20,

"Measure 3",5,

"Measure 4",5,

"")

return

if(hasonevalue[aux[measure]],Table_Measures,sum([Table_Measures])

Thanks & regards,
Pravin Wattamwar
www.linkedin.com/in/pravin-p-wattamwar

If I resolve your problem Mark it as a solution and give kudos.

Anonymous — Fri, 24 Jan 2020 14:58:46 GMT

It worked 🙂

Thank you so much!