Forum Discussion

SebKaliVith's avatar
SebKaliVith
Regular Visitor
8 years ago
Solved

Summarize table

Hi all,   I need your help for an easy trick :   I have this table :     Table1 Hospital      Step      Progress A                 Step1      50% A                 S tep2      30% A       ...
Need Help
  • v-piga-msft's avatar
    v-piga-msft
    8 years ago

    Hi SebKaliVith,

     

    You could try this formula below.

     

    Table 2 =
SUMMARIZE (
    'Table',
    'Table'[Hospital],
    "average", CALCULATE (
        AVERAGE ( 'Table'[Progress] ),
        FILTER ( 'Table', 'Table'[Hospital] = MAX ( 'Table'[Hospital] ) )
    )
)

    Here is the output you expected.

     

     

    Best  Regards,

    Cherry

jthomson's avatar
jthomson
Solution Sage
8 years ago

Just make a measure that calculates the average of the progress column, then drop that and hospital into a table

  • SebKaliVith's avatar
    SebKaliVith
    Regular Visitor
    8 years ago

    Hello,

     

    Thank you for your answer !

    But i obtain this table :

     

    TABLE 2

    Hospital     AVerage

    A                    19%

    B                     19%

    C                     19%

     

    I obtain the average of all my hospital progress, but i would like the average for each hospital.

     

     

    Any idea ?

     

    Best,

    Séb

    • jthomson's avatar
      jthomson
      Solution Sage
      8 years ago

      How have you worded your measure?