Forum Discussion
Solved
Help with relationships
Link to data and Power BI file discussed here: data and BI file Hi everyone I have been learning Power BI for a month or so and I am struggling with relationships. Images below. I am rep...
Hey,
as there is no clue in the data how the amount from the invoice table is related to a staff member the "correct" number (from a technical point of view) is provided by the measure, this can not be solved by data modeling, just by additional information or by some kind of business rule like this
per staff member and job no calculate
Measure * DIVIDE(individual hours, sum of hours by all staff members)
Regards,
Tom
Food for thought. Many thanks