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 😀
deanbland
Create a Measure like this
Percentage % =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 😀