How to incorporate the page level filters into a DAX Measure

[vishu263]

Hello,

I want to calculate the number of days on the basis of the Dates provided in the page filter using a DAX measure. For e.g if the 'Start Date' is on or after 1-Nov-2020 & 'End Date' is on or before 17-Dec-2020, we should get the output as 47 i.e. no.of days between start & end date. Please find the below snapshot for better understanding.

I tried using below measure but its not working.

NoOfDaysBetween=DATEDIFF(SELECTEDVALUE('TimeZone'[Begin]),SELECTEDVALUE('TimeZone'[End])

Thanks!

[eliasayyy]

maybe try 
NoOfDaysBetween=DATEDIFF(MAX('TimeZone'[Begin]),MAX('TimeZone'[End]),DAY)

[vishu263]

Thanks for your response @eliasayyy . The above DAX doesn't give the desired output.

[eliasayyy]

do you mind sharing sample dataset and the resuts

[vishu263]

Sure, PFB

[eliasayyy]

ok it seems you are using the same table in the filter thsi wont work in the filter panel due to when you first filter the begining date to the date , you will only have rows in the start of the date if the end date isnt in the rows it will return 0. can i se ethe table ?