Formula to ignore selection

[sweens78]

Hi Guys,

I'm just looking for a formula that will ignore a selection when clicked so for example for the below

dimension is

=valuelist($(vdashboardtable))

and within this is an expression

Count(PatientsNotAssessed_ID) 

How would I change this formula so that it still displays results before the selection is made.

So for example if they click a particular hospital the overall value will still display in a different column?

Martin

[Gabriel]

Hi,

Try this Count( {1} PatientsNotAssessed_ID)

The 1 there should ignore all selections

[sweens78]

That's great Gabriel, can you explain how this works, why {1}?

[Gabriel]

The 1 in the Set just say give me all values in the data model same as ignore selections.

Please mark if answer is correct for the benefit of someone else.

[sweens78]

I have a formula below Gabriel I tried putting {1} after count but geeting error is this different?

Num (Count(PatientsNotAssessed_ID)/count([NEWKEYID]),'##.#%'),