Forum Discussion
SELECTEDVALUE(TableDate[Date])
Hi narjissio
In measure, it will return one single value, or the alternative result is nothing selected.
Hope this will help you
Find more - https://learn.microsoft.com/en-us/dax/selectedvalue-function
If solved your requirement, please mark this answer as SOLUTION.
If this comment helps you, appreciate your KUDOS
Thanks PijushRoy,
I tried this code in a new column DisplayDate = SELECTEDVALUE(TableDate[Date], "No Single Selection"), returned me Error "Expressions that return a variant data type cannot be used to define calculated columns", then I tried the following code DisplayDate = SELECTEDVALUE(TableDate[Date], 2023-08-15) and it returned the date 1905-06-22, and that's not the right result either, given that I selected the date 2023-08-15 in the filter (date segment)