sum of averages of a visual

[Pete230]

Hi together,

I'm struggeling since a few days with the following: I have a column visual - average numbers by months, also sorted by some filters:

Now I would like to sum up all these yellow averages into one number; which should be around: 1.219.

Does anyone know how to do that?

The table and column name is: tbl_Calculations[HT [kWh/m²]]]

Thank you and regards

Pete

[Pete230 · Accepted solution]

Hi there thanks for your answer! I found a nother solution which works now:

HT Year Prgn =

If(

    HASONEVALUE(Datum[Date].[Monat]),

    [Average HT Prgn],

    SUMX(values(Datum[Date].[Monat]), [Average HT Prgn])

)

[v-rongtiep-msft]

Hi @Pete230 ,

Please have a try.

Create a measure.

measure =
AVERAGEX ( ALL ( tbl_Calculations ), tbl_Calculations[HT [kWh/m²] )

If I have misunderstood your meaning, please provide more details with the desired output and pbix file without privacy information.

Best Regards

Community Support Team _ Polly

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.