DAX filter context - rows not impacted by datesbetween

[isThatAFrog]

Hi DAX experts

I have this calculation that I want to work in a table visiual so that I can calculate before and after the slicer applied, but it only works on the total, how to change this?
I have also tried with the Window function but i could not make it work, please help:

CALCULATE(COUNTROWS('Mobility setup')

        ;DATESBETWEEN('Mobility setup'[Effective date]

        ;MINX(ALL('Mobility setup');'Mobility setup'[Effective date])

        ;MAX('Mobility setup'[Effective date])

        )

)

[v-saisrao-msft]

Hi @isThatAFrog,

Thank you @lbendlin, for your insights.

I have used the sample data and reproduced the issue at my end and got the below output also attached the pbix file for your reference:

Thank you.

[isThatAFrog · Accepted solution]

Thank you for the help @lbendlin and @v-saisrao-msft 

The sample file was very good to recreate the issue but the measue did little more than countrows()
You were right to use the date table (I didnt because I had some issues with it) and my initial formula works just fine then 
With the following formula I got the result, but you could try something similar with EXCEPT() i guess 

    CALCULATE(COUNTROWS('Mobility setup')        

        ;DATESBETWEEN('DateTable'[Date]

            ;MINX(ALL('DateTable');'DateTable'[Date])

            ;MAX('DateTable'[Date])

        )

    )

[lbendlin]

so that I can calculate before and after the slicer applied

Your slicer needs to feed from a disconnected calendar table.

And then you can use EXCEPT for a more concise filter.

[grazitti_sapna]

Hi @isThatAFrog,

Provide more details what you want to achieve, or share sample file