Forum Discussion
Use a between date slicer to filter a matrix
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.
Community Supportjbp27 ,
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.
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
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.