Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Measure with all function gives wrong total

Hello,

 

I am trying to calculate the number of hours passed on a projet by my consultants.

 

So basically I have projects and many consultants that are working on it.

 

I would like to aggregate the total hours done by all the consultant on a project (here column ttle) but it displays the wrong total.

 

Depending on that i create a measure rst that gives me the time left for the project and i can calculate the consultant work rate.

 

Here is the data model:

 

 

Here is the code for my measures :

ttle = CALCULATE( 
[Nombre Heures ttl];
ALL(SystemUser[fullname])
)

rst = [Nombre Heures vendues]-[ttle]


DIVIDE([rst]/12;151,67;0))

 

Could you please provide me some hints or a way to achieve and getting the right results ?

 

Kind regards,

 

Mohammad

3 Replies