DAX function that will bypass slicers

[chesterraepined]

I have 3 different slicer, 2 from Calendar table (Year, Month) and 1 from other table (EmpName)

I'm using the Measure below to be able to get the Total days of all the Month being sliced.

DimDate is my Calendar table

InitialResponse-Assoc is the other table

DD Total days = 
Calculate(
    Countrows('DimDate'),
    Filter('DimDate',
        'DimDate'[D Date] >= MIN('InitialResponse-Assoc'[DateTimeReceived]) &&
        'DimDate'[D Date] <= MAX('InitialResponse-Assoc'[DateTimeReceived]))
    )

But If I started applying filter for EmpName the total days for each row returns different values.

My question is, how can I still get the same DD Total days for all the row in my table visual? I need some function that would bypass the CountRows when EmpName is being sliced.

I already tried using ALL and ALLSELECTED in my measure but still no used. Seems I'm applying it incorrectly.

Thanks in advance!

[Anonymous]

Ok there are two things you are really asking, but i'll address the one that should hopefully solve your problem.  If you are doing your design work through the Power BI Desktop, you have the ability to edit the interactions between visuals.  Click on a visual and select the "Format" tab of the ribbon.  Look for "Edit Interactions".  When you toggle this on, you are able to click on your Employee Slicer and tell it not to filter the table visual.  Doing this will stop all of the filtering in that table.

Of course, you might be wanting all of the rows.  If thats the case, you want to make use of ALLEXCEPT.  This lets you specify which fields you wish to allow filtering to affect your results.