Find average of selected in slicer

[Tevon713]

Trying to find average base on user date selected in slicer. See measure yield same value and not exactly the average. Not sure what I'm doing this wrong. Please help. Thanks

Avg Mesure Test = CALCULATE (AVERAGEX ( 'Table', [CaculationMeasure] ),ALLSELECTED ( 'Table'[Date] ))

[v-shex-msft · Accepted solution]

HI @Tevon713,

I'd like to suggest you use summarize function to apply the measure calculation result in the detail level, then you can use iterator function averagex to get the average value from previous calculation results:

Avg Mesure =
AVERAGEX (
    SUMMARIZE (
        ALLSELECTED ( 'Table'[Date] ),
        [Date],
        "Result", [CaculationMeasure]
    ),
    [Result]
)

Regards,

Xiaoxin Sheng