How to Sum a row in a matrix

[Gheb_Gabriela]

Hi everyone, need some help if possible with something.

I have this situation, where all the totals are right, but only the grand total is not good. There is any solution for it?

For this metrix, i have only used a sum of total, see below 

Only this result is wrong. Maybe I think in the matrix, there are spaces for where there is no information and for them there will be 0.

If any can help with this one 🙂 Thanks a lot.

[Anonymous · Accepted solution]

Hi  @Gheb_Gabriela ,

I created some data:

Here are the steps you can follow：

1. Create measure.

Measure 2 =
var _table1=
SUMMARIZE(
    'Table','Table'[Group],"value",[Measure])
var _table2=
SUMMARIZE(
    'Table','Table'[Group2],"value",[Measure])  
return
IF(
    NOT(ISINSCOPE('Table'[Group])),
    SUMX(_table1,[value]),
    IF(
        NOT(ISINSCOPE('Table'[Group2])),SUMX(_table2,[value]),[Measure]))

2. Result:

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[Padycosmos]

Hope this video helps:

https://www.youtube.com/watch?v=6rgAkejrup8