Total Count if

[Anonymous]

I am trying to get an expression to work for me that is getting the percentage of the total count if a certain criteria is met. I currently have the below:

as my count if - count(if([Rating Field]='2017 Performance Rating',[Grouping]))

The dimensions are the different groupings (there are 4). I need to get the percentage ofcount(if([Rating Field]='2017 Performance Rating',[Grouping]))/ the total count if the rating field  is '2017 Performance Rating' as a whole.

Any help would be greatly appreciated!

[Thiago_Justen_ · Accepted solution]

I'm not sure if I got your point but you could try this out:

count(if([Rating Field]='2017 Performance Rating',[Grouping])) / count(total if([Rating Field]='2017 Performance Rating',[Grouping]))

[sunny_talwar]

Not entirely sure I understand what you want, but may be this

Count({<[Rating Field] = {'2017 Performance Rating'}>} [Grouping])
/
Count(TOTAL {<[Rating Field] = {'2017 Performance Rating'}>} [Grouping])