Forum Discussion
Calculating Correct Percentage
Hello- I am new to Power BI and I am stuck on how to calculate the percentage of hours by Department correctly. The current measure I have in place seems to work fine with the percentage of hours...
Have you tried just using your value and then dropping it down and choosing Show As | Percent of Total?
Just did that and the calculation is still off (see screenshot). The option is to change the value to "Percent of Grand Total" which may be the problem?
Alright, let's go back to basics then, sample/example data that can be copied and pasted or share your PBIX file and for the sample/exmple data, what is the expected output?
Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
Also, see this Quick Measure in the Gallery: https://community.powerbi.com/t5/Quick-Measures-Gallery/Percent-of-Total/m-p/163661