Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Displaying average with filters

Im struggling with displaying an overall average score   Using the 'Quick Meaure' feature it provides the follows   Count of Raw_Score average per metric_ref = AVERAGEX( KEEPFILTERS(VALUES('Dat...
Need Help
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    7 years ago

    Hi Anonymous ,

    You can use summarize function to apply first aggregation and use iteration function to apply second aggregation:

    Count of Raw_Score average per metric_ref =
AVERAGEX (
    SUMMARIZE (
        ALLSELECTED ( 'Data' ),
        'Data'[metric_ref],
        "Count", COUNTA ( 'Data'[Raw_Score] )
    ),
    [Count]
)

    Regards,

    Xiaoxin Sheng

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi Anonymous ,

You can use summarize function to apply first aggregation and use iteration function to apply second aggregation:

Count of Raw_Score average per metric_ref =
AVERAGEX (
    SUMMARIZE (
        ALLSELECTED ( 'Data' ),
        'Data'[metric_ref],
        "Count", COUNTA ( 'Data'[Raw_Score] )
    ),
    [Count]
)

Regards,

Xiaoxin Sheng