Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Matrix not returning the correct Total Amount

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). ...
Matrix Visual
  • Anonymous's avatar
    Anonymous
    6 years ago

    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's avatar
Anonymous
Not applicable
6 years ago

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's avatar
Anonymous
Not applicable
6 years ago

It worked 🙂

 

Thank you so much!