Stuck with Project PLEAS HELP

[Anonymous]

Hi dear PowerBI users,

I have been working and studying on my Power BI project I posted last weekend, currently I am a bit stuck an need some help, so here I go (The name are in spanish but I will provide some traduction).

• -In one table called (Registro_Lavado) all the information about how many hour you uso to clean some machine. (Date, Qty of Hours , Machine).

  • I have created 3 measures on this table to see who much hours they uso, proportion and percentage.

• - A look up table called (Maquinas), that contains the information about the machines and from what POZO (well) it get its water THIS IS VERY IMPORTANT.

• -A Calendario (Calendar)

• -Water Registry (Registro_Agua), this where every day the janitor register water usage from 3 well, POZO 2,POZO 4 and POZO 7 , right now Registro_Lavado only uses Pozo 7 for washing.

My end goal it to see how much water this machines uses in water (they only use water from POZO 2 but i have to register all the well (Pozo 4 and Pozo 7)).

I need to create a measure that gets me the total of water used by the machines.

I will leave some screenshots to get you in reference. My database is on Excel.

Relational Model

I will Leave the Excel file with the data base.

DATABASE EXCEL ONLINE 

Thanks for your time with this guys!

[Anonymous]

This problem does not have a unique solution. Here's why.


The machines are assigned to wells. There are many machines that use the same well. Take one day of work. We have the hours of work registered for each machine and we know how much water each well supplied. With this data, it's not possible to say how much water each machine used on the day.

To solve this puzzle, you have to have another assumption. For instance, if you say that the machines use the same units of water per hour for each well (it may be 0 as well if a machine does not use a particular well), then it can be solved. But you are missing this crucial piece of information to be able to say how much water each machine used for any given period of time from any given well.

Best
D

[v-lili6-msft]

hi  @Anonymous 

What is is your expected output for these sample data?

Please see this post regarding How to Get Your Question Answered Quickly:
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

Regards,

Lin

[sturlaws]

Hi @Anonymous,

perhaps avoid crossposting?

https://www.reddit.com/r/PowerBI/comments/fqxeis/stuck_in_project_pleas_help/

Cheers,
Sturla