Forum Discussion
Percentagem from a calculated value
Hi,
Assuming Total is a measure, write this measure
Measure2 = [Total]/CALCULATE([Total],ALL(Data[Projecto]))
Hope this helps.
Thank you Mariusz for your time, but I'm afraid to say that it didn't fit my problem.
The measure that I have brings me the value 744,30. If I put it on a table with the projects, it brake the value into the projects's values, as shown on the pic.
I need to calculate the percentage of that broken value of each project with the value 744,30
EVO Almoxarifado = 67,50
EVO Aplicativo = 16,80
.
.
.
So I don't know how to get each of these value and divide it by 744,30, to get the final percentage of the projects
Hi Anonymous
Can you use Excel to demostrate what is the outcome that you are expecting?
Many Thanks
Mariusz
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
Hi,
Assuming Total is a measure, write this measure
Measure2 = [Total]/CALCULATE([Total],ALL(Data[Projecto]))
Hope this helps.
Hi,
It worked!
Thank you Ashish, you saved me.
Best regards,