topic Re: How to incorporate the page level filters into a DAX Measure in DAX Commands and Tips

How to incorporate the page level filters into a DAX Measure

Anonymous — Fri, 21 Jul 2023 02:35:04 GMT

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!

Re: How to incorporate the page level filters into a DAX Measure

eliasayyy — Fri, 21 Jul 2023 08:11:45 GMT

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

Re: How to incorporate the page level filters into a DAX Measure

Anonymous — Fri, 21 Jul 2023 08:41:15 GMT

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

Re: How to incorporate the page level filters into a DAX Measure

eliasayyy — Fri, 21 Jul 2023 08:43:14 GMT

do you mind sharing sample dataset and the resuts

Re: How to incorporate the page level filters into a DAX Measure

Anonymous — Fri, 21 Jul 2023 08:58:09 GMT

Sure, PFB

Re: How to incorporate the page level filters into a DAX Measure

eliasayyy — Fri, 21 Jul 2023 09:10:32 GMT

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 ?