Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

Reply
Pete230
Helper III
Helper III

sum of averages of a visual

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:

Pete230_0-1666100015596.png

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

 

 

 

 

 

 

 

1 ACCEPTED SOLUTION
Pete230
Helper III
Helper III

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])
)

View solution in original post

2 REPLIES 2
Pete230
Helper III
Helper III

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])
)
Anonymous
Not applicable

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.

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

November Carousel

Fabric Community Update - November 2024

Find out what's new and trending in the Fabric Community.

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.