Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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:
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!
Solved! Go to 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.
@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.
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!
@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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
82 | |
66 | |
58 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |