Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
maurizio75
Frequent Visitor

Measure calculate % of flow

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] F01FeatherstoneFstones253921.14
FSTONES / PONDS[Featherstones] F02FeatherstoneFstones283121.27
FSTONES / PONDS[Featherstones] F03FeatherstoneFstones272721.23
FSTONES / PONDS[Featherstones] F04FeatherstoneFstones270321.22
FSTONES / PONDS[Featherstones] F05FeatherstoneFstones271381.22
FSTONES / PONDS[Featherstones] F08FeatherstoneFstones241681.01
FSTONES / PONDS[Featherstones] F06FeatherstoneFstones299881.67
FSTONES / PONDS[Featherstones] F07FeatherstoneFstones281941.24

 

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

[Featherstones] F0527/02/201920Fert Main Farm June2017
[Featherstones] F0627/02/201920Fert Main Farm June2017
[Featherstones] F0837/02/201920Fert Main Farm June2017
[Featherstones] F0117/02/201920Fert Main Farm June2017
[Featherstones] F0217/02/201920Fert Main Farm June2017
[Featherstones] F0317/02/201920Fert Main Farm June2017
[Featherstones] F0427/02/201920Fert Main Farm June2017
[Featherstones] F0937/02/2019 Water
[Featherstones] F0737/02/2019 Water
[Featherstones] F1047/02/2019 Water
[Featherstones] F0527/02/2019 Water
[Featherstones] F0627/02/2019 Water
[Featherstones] F0117/02/2019 Water
[Featherstones] F0217/02/2019 Water
[Featherstones] F0317/02/2019 Water
[Featherstones] F0427/02/2019 Water
[Featherstones] F0938/02/2019 Water
[Featherstones] F0528/02/2019 Water
[Featherstones] F0628/02/2019 Water
[Featherstones] F0838/02/2019 Water
[Featherstones] F0118/02/2019 Water
[Featherstones] F0218/02/2019 Water
[Featherstones] F0318/02/2019 Water
[Featherstones] F0428/02/2019 Water
[Featherstones] F0738/02/2019 Water
[Featherstones] F1048/02/2019 Water
[Featherstones] F0528/02/2019 Water
[Featherstones] F0628/02/2019 Water
2 REPLIES 2
vivran22
Community Champion
Community Champion

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.

 

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

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

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.