Forum Discussion

jbp27's avatar
jbp27
Frequent Visitor
7 years ago
Solved

Use a between date slicer to filter a matrix

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!

 

 

 

Need Help

3 Replies

  • v-yuta-msft's avatar
    v-yuta-msft
    Icon for Community Support rankCommunity Support
    7 years ago

    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's avatar
      jbp27
      Frequent Visitor
      7 years ago

      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's avatar
        v-yuta-msft
        Icon for Community Support rankCommunity Support
        7 years ago

        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.