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 ,
Basis the information provided by you in your query. I tried replicating the scenario with the sample data as shown below:
Is this what you are trying to achieve ?
Hi jaideepnema,
That is exactly what I am trying to do! How did you go about doing this?
Thanks you 🙂