Forum Discussion
chein
7 years agoFrequent Visitor
Average of Measure Total when counting active projects
Hello everybody, this is my first post so I´m sorry if I make some mistakes posting my Problem. In my Power BI file I have two tables: "Consultants" with the name of a consultant, a ...
hthota
Resolver III
7 years agoDo you need the total duration of 3rd measures in Years'
Is I am correct. if not please correct me,
Thanks,
Hemanth Thota.
chein
7 years agoFrequent Visitor
Hi hthota ,
No, thats not what i want. I want the red outlined value to be the total of the line "Days x Active Consultants" (so in fact 11377 + 10640 + 12028 ... = 108169). But I don´t think that I can adjust this measure to calculate the total right. So the first step to get into the right direction in my eyes would be to get the green outlined value to be the average of the line "Active Consultants".
Regards,
Chris