summarise filter formila DAX error

[Anonymous]

Hi Experts

is it possible to summarise data and filter the the summarise table to work out the sum of the filter data set i.e. similiar to what i am trying to achieve using DAX

STDEV.P(
    SUMMARIZE (filter ( 'Sheet1', Sheet1[OUTCOMETYPE]="Revised"), Sheet1[PRIMARYTOOUTCOMEYEARS] ),
            CALCULATE(SUM(Sheet1[PRIMARYTOOUTCOMEYEARS])))
  

[Anonymous · Accepted solution]

Hi @Anonymous ,

You can create a measure with following formula to apply multiple aggregates on filtered records:

measure =
STDEVX.P (
    SUMMARIZE (
        FILTER ( ALLSELECTED ( 'Sheet1' ), Sheet1[OUTCOMETYPE] = "Revised" ),
        [PRIMARYTOOUTCOMEYEARS],
        "Total", SUM ( Sheet1[PRIMARYTOOUTCOMEYEARS] )
    ),
    [Total]
)

Regards,

Xiaoxin Sheng

[Anonymous]

Xiaoxin Sheng

brilliant many  thanks.