Calculating Percentages

[deanbland]

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!

[jaideepnema · Accepted solution]

@deanbland 
Create a Measure like this 

Percentage % = 

var countnum=CALCULATE(COUNT(Data[KPI Checklist Outcome]),ALLEXCEPT(Data,Data[Sector]))

return DIVIDE(COUNT(Data[KPI Checklist Outcome]),countnum,BLANK())

Here is the link in case you want to download the file

https://wetransfer.com/downloads/b1ed54af5df8853a30a7e4cb9d25e67420210211120922/70a135

Please accept this as a solution if this answers your question !!

Appreciate a Kudos 😀

[jaideepnema]

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 ?

[deanbland]

Hi @jaideepnema, 

That is exactly what I am trying to do! How did you go about doing this? 

Thanks you 🙂 

[Pragati11]

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