Forum Discussion

rgoo's avatar
rgoo
Frequent Visitor
2 years ago
Solved

Custom calculation for matrix row sub total

This is my table: and this is the matrix visual i have done: right now the Total row is just summing up all the rows but what i want is to add my own custom Total's rows to achieve s...
Need Help
  • danextian's avatar
    danextian
    2 years ago

    Hi rgoo ,

     

    What measure did you write?

    For  Productivity 2023, you should be writing something like:

    Productivity 23 (2) = 
IF (
    NOT ( HASONEVALUE ( 'table'[Office column] ) ),
    [custom total measure],
    [the measure used in productivity 23 column]
)

     

danextian's avatar
danextian
Icon for Super User rankSuper User
2 years ago

Hi rgoo ,

 

What measure did you write?

For  Productivity 2023, you should be writing something like:

Productivity 23 (2) = 
IF (
    NOT ( HASONEVALUE ( 'table'[Office column] ) ),
    [custom total measure],
    [the measure used in productivity 23 column]
)

 

rgoo's avatar
rgoo
Frequent Visitor
2 years ago

ahhh i created a new measure which led to a different outcome, i understand now. Thank you