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

v-piga-msft's avatar
v-piga-msft
Resident Rockstar
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