Forum Discussion
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 want to do this for all columns in all rows.
The dataset I have looks like this (See below) and all current attempts at writing DAX formulas and calculations have failed...
Your help would be greatly appreciated.
Thanks!
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 😀
4 Replies
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
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 🙂
