Forum Discussion

rocco_guidetti's avatar
rocco_guidetti
Advocate I
9 years ago
Solved

Matrix - Measure Row Total

Dear All,   I am struggling to find the right way to compute a row total for the matrix table at the bottom.   My dataset has a structure similar to the one below:     While these are the me...
Need Help
  • rocco_guidetti's avatar
    rocco_guidetti
    9 years ago

    Hi Sean,

     

    I have found a way around to solve my issue. I am using quite a long formula but it works now.

     

    I am using VAR and RETURN to compute the same calculation for each month and then I compute the sum of all the results.

     

    Your formula was not solving my issue but probably because I framed the question not 100% clearly.

     

    Thanks a lot anyways,

    Rocco.

Sean's avatar
Sean
Community Champion
9 years ago
Absolute Difference =
IF (
    ISFILTERED ( Sheet1[Date - Month] ),
    ABS ( [Series B] - [Series A] ),
    DISTINCTCOUNT ( Sheet1[Date - Month] )
)
rocco_guidetti's avatar
rocco_guidetti
Advocate I
9 years ago

Hi Sean,

 

I have found a way around to solve my issue. I am using quite a long formula but it works now.

 

I am using VAR and RETURN to compute the same calculation for each month and then I compute the sum of all the results.

 

Your formula was not solving my issue but probably because I framed the question not 100% clearly.

 

Thanks a lot anyways,

Rocco.

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi Rocco,

     

    I am sort of stuck with the same problem, do you mind sharing your solution to the problem ? 

     

    Regards,

    Rushyendra C