Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Customized Matrix & SUM function & Customized Subtotals

Hi All,    This time I have got stucked with customised matrix.    The goal is to to have matrix with custom subtotal  A+C = 8 _____________________________________________________________...
  • Markus_Re's avatar
    Markus_Re
    5 years ago

    Hi Anonymous,

     

    could you try this for A+C:

    A+C = SUMX(FILTER(ALLSELECTED(Input), Input[Letter] = "A" || Input[Letter] = "C"), Input[Value])

    Did this answer your question? Mark my post as a solution!

Markus_Re's avatar
Markus_Re
Resolver I
5 years ago

Hi Anonymous,

 

in your "Values for Matrix"-Measure you are using the Column "Input[Letter ]", and try to select "A+C",

 

As you state above this table does not include "A+C", only the "Category"-Table does.

 

So i would suggest swapping out SELECTEDVALUE(Input[Letter ]) for SELECTEDVALUE(Category[Category]) in the Values for Matrix"-Measure

 

Hope this helps.

 

Best regards,

 

Markus

 

Did this answer your question? Mark my post as a solution!

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Thank you for your reply, 

    unfortunately it doesn't work 😞

    • Markus_Re's avatar
      Markus_Re
      Resolver I
      5 years ago

      Hi Anonymous,

       

      could you try this for A+C:

      A+C = SUMX(FILTER(ALLSELECTED(Input), Input[Letter] = "A" || Input[Letter] = "C"), Input[Value])

      Did this answer your question? Mark my post as a solution!

      • Anonymous's avatar
        Anonymous
        Not applicable
        5 years ago

        Markus_Re 
        It works great! 

        Could you advice me how to approach next issue
        I would like to have this kind of matrix 

        where A+C is the sum of both A and C but considering the category One, Two, .... 
        Currently there are no other values so the results will be
        A+C | 2 4 6 0