Forum Discussion
Solved
Calculating Percentages
Hi, I I am trying to calculate percentages based off of the total pre row. So, in row ADS, next to number 20, there would be a % value of 25% (as 25% of 79 is 20 when rounded up). I wan...
deanbland
Create a Measure like thisPercentage % =
Here is the link in case you want to download the file
var countnum=CALCULATE(COUNT(Data[KPI Checklist Outcome]),ALLEXCEPT(Data,Data[Sector]))
return DIVIDE(COUNT(Data[KPI Checklist Outcome]),countnum,BLANK())Please accept this as a solution if this answers your question !!Appreciate a Kudos 😀
Hi deanbland ,
Can you attach your sample data in a file please? Screenshot doesn't help.
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
Thanks,
Pragati