Forum Discussion

Lesny's avatar
Lesny
New Member
1 year ago
Solved

How to show to elements in summary row

Hi,

I'd like to build a matrix table which shows following summary rows for groups and in total:

is it possible? Or something just similar?

Need Help
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi Lesny ,

     

    Please try:

     

     

    Best Regards,
    Bof

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi Lesny ,

     

    I have achieved a similar result, but the table was transposed. This method has the advantage of being relatively easy to implement.

    I've made a test for your reference:
    1\I assume there is a table

    2\Create two measures

    AVG = AVERAGE(Produce_Parameter_Data[Value])
    STDEV = STDEV.P(Produce_Parameter_Data[Value])

    3\Add a Matrix

     

    Best Regards,

    Bof

    • Lesny's avatar
      Lesny
      New Member
      1 year ago

      Hi, thanks but what you did was to transform the data but how to achieve this effect in visualisation? The table (2) from your answer I have already but how to transform this table?

      • Anonymous's avatar
        Anonymous
        Not applicable
        1 year ago

        Hi Lesny ,

         

        Please try:

         

         

        Best Regards,
        Bof