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

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