Power Bi desktop timeline slicer filter with other

[AKhan]

Hi all,

I am a new in power bi desktop,and created a timeline slicer with date field(In-date) and have two  fields,In-date and  Out-date  .

need: filter count of  Out-date  field  with status using In-date field start and end date(means range)

and done following things.

1.got start and end date from In-date field on timeline slicer slicer selection(Created a measure):

StartDate = CALCULATE ( MIN( Tour[In-date].[Date]),ALLSELECTED(Tour[In-date].[Date]))

EndDate = CALCULATE ( MAX( Tour[In-date].[Date]),ALLSELECTED(Tour[In-date].[Date]))

2.count  using Out-date.

CountTest4 = CALCULATE(COUNT(Tour[In-date].[Date] ),DATESBETWEEN(Tour[Out-date].[Date],StartDate ,EndDate ))

table

Status   In-date                      Out-date

Open   20-03-2017             19-03-2017

Open   20-03-2017             20-03-2017

Close   30-03-2017            04-04-2017

Timeline slicer date selection from In-date is 19-03-2017 to 20-03-2017 and now filter from Out-date .

result should be:

Status  CountTest4

Open    2

problem: result is not coming correct.

thanks

[v-shex-msft]

Hi @AKhan,

Based on test, "datesbetween" function seems not work on dynamic date range.

You can try to use below formula to achieve your requirement.

CountTest4 = CALCULATE(COUNT('123'[In-date].[Date]),FILTER(ALL('123'),[in-date]>=[StartDate]&&[in-date]<=[EndDate] ))

Regards,
Xiaoxin Sheng

[AKhan · Accepted solution]

Hi Xiaoxin Sheng,


Thank you for reply,


But my question is that filter from another table with timeline silcer date range and this already mention query .

I have resolved this problem with create a view of a table.

Thanks

Akram