Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello,
I need to generate an average of the subtotals in the below grouping per quarter. For Q1, It is showing $469,814, but should be $100,431 (the sume of all the grouped names divided by 5).
Here is my current measure:
Cost per Day Average = AVERAGEX(VALUES('Frac Detail'[Zipper_Frac_Pad]),AVERAGEX(VALUES('Frac Detail'[Well]),DIVIDE([Daily Costs],'Frac Detail'[Frac Days])))
Any tips? Thank you.
Hi @bheinrich,
You may try to create a measure similar to:
Here is the chart using Cost per Day Average.. it's basically just averaging each name & not the grouping cost per day. I just need to find a way to average the groupings.
This looks like a measure aggregation problem. See my blog article about that here: https://community.powerbi.com/t5/Community-Blog/Design-Pattern-Groups-and-Super-Groups/ba-p/138149
User | Count |
---|---|
139 | |
113 | |
104 | |
77 | |
63 |
User | Count |
---|---|
135 | |
126 | |
110 | |
70 | |
61 |