Re: Calculating Summary

jaredseal · ‎09-12-2019

I am wanting to be able to calculate a measure at the most detailed level, but also have that same meausre calculate on a group that the most detail belongs to.

Well Master Table

Engineering Field
- Well

Each well is part of an Engineering Field.

All data is recorded at the well level. I want be able to see a total cost for the well and a total cost for the Engineering Field. I would be summarizing a measure called "Total Fixed Cost"

Ultimately, I will use switch to use the Well calculation if there is 12 monts of data, if not use the Engineering Field calculation.

Any thoughts?

parry2k · ‎09-12-2019

@jaredseal please share sample data with expected result.

Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤

Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

jaredseal · ‎09-13-2019

So many wells belong to an engineering field. We want to see the wells specific calculation of a given measure and the same measure for the Engineering field the well belongs to.

Below is a screenshot of the well table which is tied to our fact table.

So many wells belong to an engineering field. We want to see the wells specific calculation of a given measure and the same measure for the Engineering field the well belongs to. @parry2k

Calculating Summary

Helpful resources

Microsoft Fabric Learn Together

Power BI Monthly Update - April 2024

Fabric Community Update - April 2024

How to Get Your Question Answered Quickly