Forum Discussion

Raul's avatar
Raul
Icon for Post Patron rankPost Patron
8 years ago
Solved

Total is wrong in a matrix

Hello,   I have this matrix visualization:       The value of the matrix it's a measure like this: Hour = IF(SELECTEDVALUE(Calendar[Year])=2017;SUM(T1[Hours]);IF(SELECTEDVALUE(T2[Type])="A...
Need Help
  • v-ljerr-msft's avatar
    v-ljerr-msft
    8 years ago

    Hi Raul,

     

    Could you try using the formula below to create a new measure to see if it works? :smileyhappy:

    Measure = SUMX ( SUMMARIZE ( T2; T2[Type]; "abc"; [Hour] ); [abc] )

     

    Regards

Raul's avatar
Raul
Icon for Post Patron rankPost Patron
8 years ago

Ok, thank you Zubair_Muhammad but now, the total row is wrong:

 

 AbonoExpedientTotal
AL55,0037,0092,00
AM166,00 166,00
AO157,002,75159,75
GG113,5029,00142,50
JB411,42 411,42
JP117,7536,25154,00
JS0,00 0,00
MA0,00 0,00
MG123,75 123,75
RB0,00 0,00
SR0,00 0,00
TM0,00 0,00
 Total88120,088085,0096205,08

 

Any idea?

v-ljerr-msft's avatar
v-ljerr-msft
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

Hi Raul,

 

Could you try using the formula below to create a new measure to see if it works? :smileyhappy:

Measure = SUMX ( SUMMARIZE ( T2; T2[Type]; "abc"; [Hour] ); [abc] )

 

Regards