Forum Discussion

rocco_guidetti's avatar
rocco_guidetti
Icon for Advocate I rankAdvocate 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:

 dataset 

While these are the measures that I am using to compute the monthly quantities for each series and the absolute difference to be visualized in the matrix:

 

Series A = SUMX(FILTER(Sheet1;Sheet1[Series]="A");Sheet1[Qty])

Series B = SUMX(FILTER(Sheet1;Sheet1[Series]="B");Sheet1[Qty])

Absolute difference = abs([Series B]-[Series A])

 

As you can see I would like to highlight the monthly absolute difference among the two series and the total of the absolute difference column. Correclty the DAX returns 0 for that row total but I would appreciate any suggestion to compute, maybe with another measure, the total of the absolute deviation (12 in this case).

 

 

what I am trying to achieve

 

Thank you for your help,

Rocco.

 

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.

3 Replies

  • Sean's avatar
    Sean
    Icon for Community Champion rankCommunity 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
      Icon for Advocate I rankAdvocate 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