Forum Discussion
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])="Abono";SUM(T2[Hours]);SUM(T1[Hours])))
Bescause I need sum the hours of the records from one table if it's values are from 2017 and sum the hours of the other table, if the type is "Abono" otherwise. The Abono and Expedient columns are correct but, why the Total column it's wrong? Is the Total column not the sum of the Abono and Expedient columns?
Thank you.
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
3 Replies
HI Raul
Try this MEASURE
Measure = IF ( HASONEVALUE ( TableName[Colaborador] ), [Hour], SUMX ( ALLSELECTED ( TableName[Colaborador] ), [Hour] ) )Ok, thank you Zubair_Muhammad but now, the total row is wrong:
Abono Expedient Total AL 55,00 37,00 92,00 AM 166,00 166,00 AO 157,00 2,75 159,75 GG 113,50 29,00 142,50 JB 411,42 411,42 JP 117,75 36,25 154,00 JS 0,00 0,00 MA 0,00 0,00 MG 123,75 123,75 RB 0,00 0,00 SR 0,00 0,00 TM 0,00 0,00 Total 88120,08 8085,00 96205,08 Any idea?
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
