Use a between date slicer to filter a matrix

[jbp27]

Hello all,

I tried to expand a solution which has already been working for me, but now with a range of dates, not with a single selection of a date;

I have a between date slicer where the selection of the two dates is captured by two measures, so far so good.

(the measures are called [MIN] and [MAX] here)

Then I create another measure:

ChosenDate =

IF (

[MAX] <= SELECTEDVALUE (Query1[REPORTING_DATE])

&& [MIN] <= SELECTEDVALUE (Query1[REPORTING_DATE]);

1

)

This measure shall be used as a visual level filter being "1", so that if any row where the Reporting Date is inside the interval chosen from

the slicer, all measure inside my matrix visual are adjusted accordingly (this used to work for choosing a single date).

Right now when applying this, I somehow get no output in my matrix, although the date range is defined by the range of reporting dates which are in the data.

Do I miss something in this logic?

Thanks for the help!

[v-yuta-msft]

@jbp27 ,

You can't use SELECTEDVALUE() when you select a range of date period. In addtion, if possible, please share some sample data and give the expected result.

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[jbp27]

Hi @v-yuta-msft ,

so is there any equivalent function for data ranges? 

I just found another solution for my problem, but I would be interested in something like SELECTEDVALUE for a data range, not only for a single date being selected.

Thanks for your help!

[v-yuta-msft · Accepted solution]

@jbp27 ,

You may try ALLSELECTED(Table)/ALLSELECTED(Table[Column]). However, this function always be used in CALCULATE() and FILTER(). 

Reference: https://docs.microsoft.com/en-us/dax/allselected-function-dax

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.