Matrix not returning the correct Total Amount

Question

Hello,&nbsp;I would like to build a matrix that would return the correct total amount.&nbsp;The rows on this matrix are pre-defined by an&nbsp;auxiliary table (since I want want them to follow that Order).&nbsp;The auxiliary table that looks like the following:&nbsp;Measure&nbsp; &nbsp; &nbsp; &nbsp;IndexMeasure 11Measure 22Measure 33Measure 44&nbsp;And a measure is the following:Table_Measures = SWITCH(&nbsp; &nbsp; &nbsp;LASTNONBLANK(Aux[Measure],1),&nbsp; &nbsp; &nbsp;"Measure 1",10,&nbsp; &nbsp; &nbsp;"Measure 2",20,&nbsp; &nbsp; &nbsp;"Measure 3",5,&nbsp; &nbsp; &nbsp;"Measure 4",5,"")&nbsp;I would like my Matrix to return the correct total (40), and instead returns amount 5:&nbsp;Any help would be much appreciated. 🙂

anonymous · Accepted Answer

Try something like&nbsp;Total=var Table_Measures = SWITCH(&nbsp; &nbsp; &nbsp;LASTNONBLANK(Aux[Measure],1),&nbsp; &nbsp; &nbsp;"Measure 1",10,&nbsp; &nbsp; &nbsp;"Measure 2",20,&nbsp; &nbsp; &nbsp;"Measure 3",5,&nbsp; &nbsp; &nbsp;"Measure 4",5,"")&nbsp;returnif(hasonevalue[aux[measure]],Table_Measures,sum([Table_Measures])&nbsp;&nbsp;Thanks &amp; regards,Pravin Wattamwarwww.linkedin.com/in/pravin-p-wattamwarIf I resolve your problem Mark it as a solution and give kudos.

Forum Discussion

Matrix not returning the correct Total Amount

2 Replies

Related content

Drill Through not returning correct values

Correcting Data

Using getDataFieldDisplayName for Field Paramter does not return correct values

Dax Formula correction help

Dax correction

Measure 1	1
Measure 2	2
Measure 3	3
Measure 4	4