topic Re: Need Help: Average the % gas fills by each Department. in DAX Commands and Tips

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

FOZZY — Wed, 18 Jan 2023 08:28:43 GMT

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!!

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

FreemanZ — Wed, 18 Jan 2023 10:04:55 GMT

hi FOZZY

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

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

FOZZY — Mon, 23 Jan 2023 15:34:27 GMT

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.

Area	Account No	Submission No	Sequence by Account no	FillDate	Assigned Fill Frequency (Days)	Frequency Variance (Days)	Total Tanks Capacity	Total Quantity Delivered	Total % Filled	Fill Target %	Fill Target Variance (% points)
E101	8018879	SN4177028	0	1/20/2022	35	-35	750	373	50%	60%	-10
E101	8018879	SN4198336	1	2/12/2022	35	-12	750	399	53%	60%	-7
E101	8018879	SN4228695	2	3/16/2022	35	-3	750	371	49%	60%	-11
E101	8018879	SN4255589	3	4/13/2022	35	-7	750	205	27%	60%	-33
C101	8023107	SN4297848	0	5/26/2022	98	-98	12000	2005	17%	60%	-43
C101	8023107	SN4357194	1	7/27/2022	98	-36	12000	2274	19%	60%	-41
W101	8023527	SN4177421	0	1/20/2022	21	-21	6600	3972	60%	60%	0
W101	8023527	SN4187176	1	1/31/2022	21	-10	6600	2458	37%	60%	-23
W101	8023527	SN4206944	2	2/22/2022	21	1	6600	4040	61%	60%	1
E102	8025005	SN4206612	0	2/21/2022	28	-28	4000	3065	77%	60%	17
E102	8025005	SN4318232	1	6/16/2022	28	87	4000	4260	107%	60%	47

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

FOZZY — Sat, 04 Feb 2023 02:24:48 GMT

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.

Area	Account No	Submission No	Sequence by Account no	FillDate	Assigned Fill Frequency (Days)	Frequency Variance (Days)	Total Tanks Capacity	Total Quantity Delivered	Total % Filled	Fill Target %	Fill Target Variance (% points)
E101	8018879	SN4177028	0	1/20/2022	35	-35	750	373	50%	60%	-10
E101	8018879	SN4198336	1	2/12/2022	35	-12	750	399	53%	60%	-7
E101	8018879	SN4228695	2	3/16/2022	35	-3	750	371	49%	60%	-11
E101	8018879	SN4255589	3	4/13/2022	35	-7	750	205	27%	60%	-33
C101	8023107	SN4297848	0	5/26/2022	98	-98	12000	2005	17%	60%	-43
C101	8023107	SN4357194	1	7/27/2022	98	-36	12000	2274	19%	60%	-41
W101	8023527	SN4177421	0	1/20/2022	21	-21	6600	3972	60%	60%	0
W101	8023527	SN4187176	1	1/31/2022	21	-10	6600	2458	37%	60%	-23
W101	8023527	SN4206944	2	2/22/2022	21	1	6600	4040	61%	60%	1
E102	8025005	SN4206612	0	2/21/2022	28	-28	4000	3065	77%	60%	17
E102	8025005	SN4318232	1	6/16/2022	28	87	4000	4260	107%	60%	47