Distinct Count set Analysis ignore any selections

[shaan007]

Hi,

I have an admission data model with many tables.

When I calculate a KPI (in text Object)

=count(PK_ADMISSION) returns 17,564 which is correct PK_ADMISSION  has one to many links in the data model

=count(DISTINCT PK_ADMISSION) im getting a value 35,747 which is correct

=count({1} DISTINCT PK_ADMISSION) returns 35,747

how do i Count Distinct value of a selected Field (Hospital) while ignore all other selections?

[Clever_Anjos · Accepted solution]

=count({1} DISTINCT PK_ADMISSION) should be correct

Would you mind sharing your app? Preparing examples for Upload - Reduction and Data Scrambling

[Clever_Anjos]

A "brute force" approach is creating an Alternate State and putting that text box in that state with =count(DISTINCT PK_ADMISSION)  as expression

[shaan007]

=count({1<[Hospital Desc] =$::[Hospital ]>} DISTINCT PK_ADMISSION)