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.

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Sure Mariusz , I can show you on the image below

 



I need to divide the total column by total All projects.

 

I sum up all the rows where employee1 and employee2 worked. They are from the test department.

I know that the test department worked on a project by the column timeworked. 

I am making a report to display the hours spent on each project. The values from the grid that I've put on the first was gathered with the measure.

The real point, is how to calculate the percentage from the projects where the test department worked.

 

This is my dataset.

 

I really appreciate your help

Ashish_Mathur's avatar
Ashish_Mathur
Super 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,