March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe 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
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
Solved! Go to Solution.
Hi there thanks for your answer! I found a nother solution which works now:
Hi there thanks for your answer! I found a nother solution which works now:
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.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
User | Count |
---|---|
90 | |
89 | |
85 | |
73 | |
49 |
User | Count |
---|---|
169 | |
144 | |
90 | |
70 | |
58 |