calculate amount out of total non selected

[amber2000]

Hello boys and girls,

What I'm trying to do is show the amount of stores that are selected out of all the stores present.

There are 100 Stores and I've selected 20 of them so my result should be 20 / 100

This is my expression but the value on the left is the same as the value on the right:

=COUNT(Distinct(Store_ID)) & ' / ' & COUNT(Distinct(Store_ID))

Does anyone know how to fix this please?

Kind regards,

Monique

[tresesco]

I am sure you meant differently. But to make it more clear to all who visit this thread and not much familiar with ALL :

ALL is equivalent to  {1}+TOTAL

Sum(Total {1} Sales) ==Sum(ALL Sales)

[amber2000]

Hi Tony,

Your solution does work to so thank you for sharing this with me.

Kind regards,

Monique

[amber2000]

Hi Manuel

The expression for % selected gives me for example 8 / 3154 when I select 8 stores

When I try the expression for % not selected then I get 756 / 3154  --> This is strange because to me it should be 3146 ???

[Anonymous]

Hi Monique, I need to see your model and document to answer this question to you correctly.

Thanks!

[tresesco]

Do you claim that {1} would also disrespect the dimension in a chart ? But I don't find it behaving like that. Please refer the screen shot:

Am I missing something?

[ToniKautto]

I stand corrected. Too late for me.