Percentage of total row count ignoring other dimension filters

[#1]

I have a simple bar chart that displays the total record count of some dimension members using the expression 'count (distinct expr )'

Lets say one of the bars measures 55,000.

If I filter using another dimension the count is now 22000.

I am trying to add an expression to the same bar chart that will show this as a percentage - 22000 / 55000.

'count (total expr )' also gives me 22000.

What expression will give me 55000 regardless of other dimension filters so that I can display the percentage?

Many Thanks

Sandy

[#2]

Can you try the following...

count(total(expr))

[eric_dielessen · Accepted solution]

count({1} distinct expr) should do the trick.

[#4]

count ( {1} distinct expr ) did the trick - thanks!

[#5]

Hi,

If you are using QV 8.5 then you should be able to solve this fairly easy with SET analysis.

Where Dim1 is the dimension you filtered on. You could add more Dimensions if you like. Seperated with comma.

count (distinct {$<[Dim1]={*},[Dim2]={*}>} Expr)

best regards,

Johan

[#6]

Thanks all for your answers.

The answer from eric was exactly what I was looking for.