Measure with all function gives wrong total

[mmp]

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

[amitchandak]

Refer, if this can help

https://community.powerbi.com/t5/Desktop/Percentage-of-subtotal/td-p/95390

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution.
In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blogs -Decoding Direct Query - Time Intelligence, Winner Coloring on MAP, HR Analytics, Power BI Working with Non-Standard TimeAnd Comparing Data Across Date Ranges
Connect on Linkedin

[mmp]

@amitchandak thank you for your answer but in the link you gave me, it's not the same problem.

Kind regards,

Mohammad PATEL

[v-diye-msft]

Hi @mmp 

You might consider creating pbix file that will contain some sample data (remove the confidential info), upload the pbix to onedrive or dropbox and share the link to the file.