expression help

[#1]

Hi,

Hoping for some help. I rasied a question a while ago for help with a calculation. I was kindly provided with the following expression to calculate decency. It workes, in that it provided a figure and matches at an overall level; however, when I then click our neighbourhood filter it doesn't then match the detail:

Num(Count ({<[Decency]= {Decent}>} [Decency])/ Count({1} [Decency]), '#,##0.00%') 

So to clarify when looking at figures overall the expression below matches the detail:

Overall

Decency                              Count                 %

Decent                                    4376             30.01%

Non decnt                                 199             1.36%

Potnetially Non Decent        10009           68.63%

However, when selecting a neighbourhood no longer works:

In Monton and Ellesmere we have the following breakdown; however, the expression above gives us a figure of 0.77%:

Decency                              Count             %

Decent                                    112           18.54%

Non decnt                                 52           8.61%

Potnetially Non Decent          440        72.85%

...?

[#2 · Accepted solution]

Hi Chris,

Count({1} [Decency]  will give always the full count of decency.

If you want it to work with selection use  Count(total [Decency] )

best regards

Chris