Set analysis shows correct value when nulls enabled

[arazadisqr]

Hello!

I'm having an issue where  If I Enable the show null values for my date field the values show correctly in a pivot table , without the nulls it does not.. (is there a way to add in nulls in the value without enabling?)

No issue in a text object though.  Here is the expression

COUNT(DISTINCT{<AuthorizedSheet = P($::Sheet),Sheet=> } TOTAL<EmployeeStaffLevelDescription,Practice>[clientUniqueIdentifier.userId])

Thank you !

Without Nulls

Month	Oct-2019	Sep-2019	Aug-2019	Jul-2019
Staff Level	Authorized Users	Authorized Users	Authorized Users	Authorized Users
Totals	7,770	7,770	7,770	7,770
Administration	1,208	1,208	1,208	1,208
Associate	16	16	16	16
Manager	1,233	1,233	1,233	1,233
Managing Director	889	889	889	889
Paraprofessional	5	5	5	5
Partner	1,915	1,915	1,915	1,915
Senior Associate	53	53	53	53
Sr. Manager / Director	2,451	2,451	2,451	2,451

With Nulls

Month	-	Oct-2019	Sep-2019	Aug-2019
Staff Level	Authorized Users	Authorized Users	Authorized Users	Authorized Users
Totals	11,992	11,992	11,992	11,992
-	36	36	36	36
Administration	1,554	1,554	1,554	1,554
Associate	34	34	34	34
Manager	2,783	2,783	2,783	2,783
Managing Director	1,086	1,086	1,086	1,086
Paraprofessional	7	7	7	7
Partner	2,248	2,248	2,248	2,248
Senior Associate	131	131	131	131
Sr. Manager / Director	4,113	4,113	4,113	4,113

[sunny_talwar]

May be this

Count(DISTINCT {<AuthorizedSheet = P($::Sheet), Sheet, [Staff Level] *= {"*"}, Month *= {"*"}>} TOTAL <EmployeeStaffLevelDescription, Practice> clientUniqueIdentifier.userId])

[arazadisqr]

Showing Same results

[sunny_talwar]

Would you be able to share a sample where we can see the issue?

[arazadisqr]

wont be able to but let me see if i can share something with you that can help in further investigating.  Thanks!