Forum Discussion

MeyerRy's avatar
MeyerRy
Frequent Visitor
2 years ago
Solved

Grand Total on Matrix Help

I have the following measure that is mostly working. I just need to get the grand total working. See line 23 where I hard keyed "321" and then see the matrix output. I am wanting everything in the Av...
  • lbendlin's avatar
    2 years ago

    The correct-ish way is to use HASONEVALUE and a SWITCH statement

     

    SWITCH(TRUE(),

    HASONEVALUE(row) && HASONEVALUE(column),"Cell",

    HASONEVALUE(row),"Column Total",

    HASONEVALUE(column),"Row Total",

    "Grand Total")