Reply
FOZZY
Frequent Visitor

Need Help: Average the % gas fills by each Department.

Hello.

I am trying to calculate an average fill percentage for each area for gas deliveries.  I cannot seem to find a solution to this anywhere.  I would appreciate any guidance on this.  Screenshot below. Thank you!!

 

FOZZY_2-1674030337682.png

 

 

3 REPLIES 3
FOZZY
Frequent Visitor

Hi everyone.

I am trying to calculate an average fill percentage for each area's gas deliveries.  I cannot seem to find a solution to this anywhere.  I would appreciate any guidance on this.  Data table is below.  Please let me know if there is additional information needed.  Thank you!!

 

1.  Show average %Filled broken down by AREA in a time period.
2.  Be able to show all of the TOTAL % FILLS that are below the Target of 60%.  Again, broken down by area.

 

Thank you for your time.

AreaAccount NoSubmission NoSequence by Account noFillDateAssigned Fill Frequency (Days)Frequency Variance (Days)Total Tanks CapacityTotal Quantity DeliveredTotal % FilledFill Target %Fill Target Variance (% points)
E1018018879SN417702801/20/202235-3575037350%60%-10
E1018018879SN419833612/12/202235-1275039953%60%-7
E1018018879SN422869523/16/202235-375037149%60%-11
E1018018879SN425558934/13/202235-775020527%60%-33
C1018023107SN429784805/26/202298-9812000200517%60%-43
C1018023107SN435719417/27/202298-3612000227419%60%-41
W1018023527SN417742101/20/202221-216600397260%60%0
W1018023527SN418717611/31/202221-106600245837%60%-23
W1018023527SN420694422/22/20222116600404061%60%1
E1028025005SN420661202/21/202228-284000306577%60%17
E1028025005SN431823216/16/2022288740004260107%60%47

 

FreemanZ
Super User
Super User

hi @FOZZY 

you may get a solution quicker if you paste your sample data as text.

Sorry for the delay in response.  Below is a sample of the data.  What I am looking to do in visuals is 
1.  Show average percent fill amount per area in a time period determined by a slicer.
2.  Be able to show all of the Total % fills that are below the Target %.  Broken down by area. 

Thank you for your time.

AreaAccount NoSubmission NoSequence by Account noFillDateAssigned Fill Frequency (Days)Frequency Variance (Days)Total Tanks CapacityTotal Quantity DeliveredTotal % FilledFill Target %Fill Target Variance (% points)
E1018018879SN417702801/20/202235-3575037350%60%-10
E1018018879SN419833612/12/202235-1275039953%60%-7
E1018018879SN422869523/16/202235-375037149%60%-11
E1018018879SN425558934/13/202235-775020527%60%-33
C1018023107SN429784805/26/202298-9812000200517%60%-43
C1018023107SN435719417/27/202298-3612000227419%60%-41
W1018023527SN417742101/20/202221-216600397260%60%0
W1018023527SN418717611/31/202221-106600245837%60%-23
W1018023527SN420694422/22/20222116600404061%60%1
E1028025005SN420661202/21/202228-284000306577%60%17
E1028025005SN431823216/16/2022288740004260107%60%47

 

avatar user

Helpful resources

Announcements
March PBI video - carousel

Power BI Monthly Update - March 2025

Check out the March 2025 Power BI update to learn about new features.

March2025 Carousel

Fabric Community Update - March 2025

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

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)