Hello,I asked a question yesterday and have a little more information to provide!So, my goal is to calculate the total reading/output of a specific city and compare it to what is required by law. I take the last 90 days of readings to calculate this.Here's what I want: the average readings by specific equipment, and then the total of the averages (picture attached)
Right now, I have a measure that calculates the # of readings in the last 90 days, the sum of the readings, and it divides to find the total average.Measure =
The measure above is essentially performing this...
It combines all the values and calculates a total average. Instead, I would want a measure that adds 250, 350, and 324 to give me a total "average" of 924.Please let me know if I need to add any other info for help.Thanks!
Go to Solution.
The below formula should work for your requirment.
View solution in original post
Take a look at the September 2023 Power BI update to learn more.
Join Microsoft Reactor and learn from developers.