Measure calculate % of flow

[maurizio75]

Hi all,

I am trying to solve a measure in power pivot creating a measure in a power pivot table.

I have two tables, one listing block details, the second one is listing actual records of blocks being watered; and the two table sare connected by Valve/ Block

I have a third tables with days of the year, weeks...

I am trying to make a power pivot table with Stage and Valves as rows and week of the year as coloumn.

As measure I would like to have the sum of the flow (l/hr) specific to each valve divided by the sum of the flow (l/hr) belonging to all the blocks with same stage, same shift number and Fert restrict (L/hr) different from 0.

Can anyone help?

Thanks

Stage                              Valve                               System                  Fert Tank  Flow (l/hr)  Area (ha)

FSTONES / PONDS	[Featherstones] F01	Featherstone	Fstones	25392	1.14
FSTONES / PONDS	[Featherstones] F02	Featherstone	Fstones	28312	1.27
FSTONES / PONDS	[Featherstones] F03	Featherstone	Fstones	27272	1.23
FSTONES / PONDS	[Featherstones] F04	Featherstone	Fstones	27032	1.22
FSTONES / PONDS	[Featherstones] F05	Featherstone	Fstones	27138	1.22
FSTONES / PONDS	[Featherstones] F08	Featherstone	Fstones	24168	1.01
FSTONES / PONDS	[Featherstones] F06	Featherstone	Fstones	29988	1.67
FSTONES / PONDS	[Featherstones] F07	Featherstone	Fstones	28194	1.24

Block                                 Shift        Date         Fert Restrictor (L/hr) 1         Fert mix type

[Featherstones] F05	2	7/02/2019	20	Fert Main Farm June2017
[Featherstones] F06	2	7/02/2019	20	Fert Main Farm June2017
[Featherstones] F08	3	7/02/2019	20	Fert Main Farm June2017
[Featherstones] F01	1	7/02/2019	20	Fert Main Farm June2017
[Featherstones] F02	1	7/02/2019	20	Fert Main Farm June2017
[Featherstones] F03	1	7/02/2019	20	Fert Main Farm June2017
[Featherstones] F04	2	7/02/2019	20	Fert Main Farm June2017
[Featherstones] F09	3	7/02/2019		Water
[Featherstones] F07	3	7/02/2019		Water
[Featherstones] F10	4	7/02/2019		Water
[Featherstones] F05	2	7/02/2019		Water
[Featherstones] F06	2	7/02/2019		Water
[Featherstones] F01	1	7/02/2019		Water
[Featherstones] F02	1	7/02/2019		Water
[Featherstones] F03	1	7/02/2019		Water
[Featherstones] F04	2	7/02/2019		Water
[Featherstones] F09	3	8/02/2019		Water
[Featherstones] F05	2	8/02/2019		Water
[Featherstones] F06	2	8/02/2019		Water
[Featherstones] F08	3	8/02/2019		Water
[Featherstones] F01	1	8/02/2019		Water
[Featherstones] F02	1	8/02/2019		Water
[Featherstones] F03	1	8/02/2019		Water
[Featherstones] F04	2	8/02/2019		Water
[Featherstones] F07	3	8/02/2019		Water
[Featherstones] F10	4	8/02/2019		Water
[Featherstones] F05	2	8/02/2019		Water
[Featherstones] F06	2	8/02/2019		Water

[vivran22]

Hello @maurizio75 ,

Your second table is not clear in terms of column headers and corresponding values. Can you share the excel file?

Cheers!
Vivek

Blog: vivran.in/my-blog
Connect on LinkedIn
Follow on Twitter

[maurizio75]

Hi Vivek,

thanks for your reply.

Any chance you can give me your email address through a private message?

I would like to send you the file by email if possible.