AverageX subtotals are SUM instead of Average in Matrix.

[Daniel_Derbin]

Hi, 

I'm using below Measure to calculate Averages on hosts, and that works fine on day level, however when using date hierarchy in Matrix the subtotals are suming up the results instead of showing average for weeks, months etc.
Any ideas why?

Open Average on host =

CALCULATE(

    AVERAGEX(VALUES(TSCDB_Prod_BACKUP[Host Name]),[Open]))

[Jihwan_Kim · Accepted solution]

Hi,

I am not sure how your datamodel looks like, but please try writing something like below whether it works.

Open Average on host =
AVERAGEX (
    SUMMARIZE ( 'FactTableName', TSCDB_Prod_BACKUP[Host Name], 'Calendar'[Date] ),
    [Open]
)

[Daniel_Derbin]

Jihwan, 

That worked perfectly, thank you!! 🙂