Ignore Date Slicer on Page

[Anonymous]

I've got several tables linked together that work perfectly, but now I need a measure that ignores the Date Table but updates when my sales manager selects different sales people in their territory.

This is my formula that works for all my customers, but now I need to tack on additional direction that tells it not to change regardless of the data slicer being changed.  So I'll have two numbers on the page telling my sales director the total number of customers his sales person has (the new formula) and the total number during a specific time period (what I have now, listed below).

C Count = CALCULATE(DISTINCTCOUNT('All ISPs'[ISP Name]),ALLSELECTED('All ISPs'[ISP Name]))

I've tried adding ALLEXCEPT:

C Count All Except Date= CALCULATE(DISTINCTCOUNT('All ISPs'[ISP Name]),ALLSELECTED('All ISPs'[ISP Name]),ALLEXCEPT('Distinct Calendar Date','Distinct Calendar Date'[EOM].[Date]))

But that has absolutely no bearing on the result.  The Distinct Calendar Date is the date table that I use for the slicer on the page.

What am I doing wrong?  Thanks for any help.

[v-yulgu-msft]

Hi @Anonymous ,

Please try this:

C Count All Except Date =
CALCULATE (
    DISTINCTCOUNT ( 'All ISPs'[ISP Name] ),
    ALL ( 'Distinct Calendar Date'[EOM].[Date] )
)

Regards,

Yuliana Gu

[Anonymous]

It still changed with the date slicer. 

[Anonymous · Accepted solution]

I was able to figure out that if I used the Interactions options I could make it work.