Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Percentagem from a calculated value

I have a calculated value that filter the hours worked from two employee.   They work on several projects, and I got the amount of hours with the following measure   Hours = ...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    7 years ago

    Hi,

    Assuming Total is a measure, write this measure

    Measure2 = [Total]/CALCULATE([Total],ALL(Data[Projecto]))

    Hope this helps.

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
7 years ago

Hi,

Assuming Total is a measure, write this measure

Measure2 = [Total]/CALCULATE([Total],ALL(Data[Projecto]))

Hope this helps.

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi, 

 

It worked!

 

Thank you Ashish, you saved me.

 

Best regards,