Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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 |
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
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.
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
25 | |
10 | |
7 | |
6 | |
6 |
User | Count |
---|---|
30 | |
11 | |
11 | |
10 | |
6 |