topic Re: How to count number of days selected from SLICER in DAX Commands and Tips

How to count number of days selected from SLICER

Anonymous — Wed, 14 Apr 2021 01:45:53 GMT

Hi,

I want to count number of days regardless of checking that if data is in database or not. All I want is when user select date range from slicer either days or months or years. It should count the number of days including weekends and just display number of days.

For example :

Number of days = 3

Number of days = 3 * 7 = 21 days

At the moment I get count of days for which data exist in database. Whereas I want to count total number of days selected even if data is not present in database. Thanks

Re: How to count number of days selected from SLICER

amitchandak — Wed, 14 Apr 2021 03:04:06 GMT

Anonymous , On you slicer column, try a measure like

measure =
var _max = maxx(ALLSELECTED('Date'),'Date'[Date])
var _min = minx(ALLSELECTED('Date'),'Date'[Date])
return
datediff(_min,_max,day)+1

Re: How to count number of days selected from SLICER

Anonymous — Wed, 14 Apr 2021 03:31:50 GMT

It's not working when I use the below selection I get Number of days 1 instead of 3 :

Re: How to count number of days selected from SLICER

Anonymous — Wed, 14 Apr 2021 03:38:47 GMT

Because I don't have data in database for date 13/04/2021 and 14/04/2021. But I want to count number of days regardless of data in database.

Re: How to count number of days selected from SLICER

Anonymous — Wed, 14 Apr 2021 03:41:38 GMT

Please see below screenshots :

Showing that it brings the max date from database instead of getting it from slicer.

Re: How to count number of days selected from SLICER

amitchandak — Wed, 14 Apr 2021 04:17:57 GMT

Anonymous , we do not have a way to know other parameters from the relative date slicer. So if dates are not present, I doubt of a way I know.

Re: How to count number of days selected from SLICER

angelarojasmora — Tue, 24 May 2022 15:18:43 GMT

Thanks! This solution worked for me. I had problems with the function "AVERAGEX(VALUES ....", so I replaced it with your suggestion and it worked.