Sum of Distinct Count by Month and CYTD

[atowriss74]

I have a simple table that looks like below.  I want to get a sum/total of Unique Claim numbers by month (users have a date slicer to choose).  

I tried just Distinct Count(# Unique ClaimsProcessed = DISTINCTCOUNT('Claims Pmts Processed Upload'[Claim #]), but it doesn't change when I choose a specific month from the slicer .  I aslo tried this

# Unique ClaimsProcessed = calculate(DISTINCTCOUNT('Claims Pmts Processed Upload'[Claim #]),'Dates_Table Indep'[Date])... and the slicer still doens't impact.  Dates are linked and active with Date Table.

What am I missing..this should be simple

[v-henryk-mstf · Accepted solution]

Hi @atowriss74 ,

Based on your description, do you create formulas that retain an external filtering context (such as a date field).
Refer to the following formulas (one contains a date filter, one does not)

M_ = CALCULATE(DISTINCTCOUNT('Table'[Category]),ALL('Table'))

M_slicerDate =
CALCULATE (
    DISTINCTCOUNT ( 'Table'[Category] ),
    ALLEXCEPT ( 'Table', 'Table'[Date] )
)

If the problem is still not resolved, please provide detailed error information and test data. Looking forward to your reply.

Best Regards,
Henry

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[mangaus1111]

Hi @atowriss74 ,

in the link below you find the pbi file. In my file the slicer works good.

https://1drv.ms/u/s!Aj45jbu0mDVJiG2gubFw9YrtOIpP?e=oxApUl 

Please hit the thumb and accept my answer as solution!!!