Measure to Return Date when a slicer is selected

[Anonymous]

Hello Experts,

I am trying to create a measure in which I want to return the date of entry only if its ID no is selected from Slicer.
 

I am trying below DAX query in measure =   IF(ISFILTERD(Table[id]),VALUE(Table[Date])," -")

I want to keep the result blank until the ID is selected as I am showing this date in a Batch Card.

the result i am getting is -#,0.00
Can someone please help me to resolve this issue?

[v-lid-msft]

Hi @Anonymous ,

Has this issue been solved?  We can also use the following measure to meet your requirement:

measure =
IF (
    HASONEVALUE ( Table[id] ),
    VALUES ( Table[Date] ),
    BLANK ()
)

Best regards,

[Anonymous]

Hi @v-lid-msft ,

Yes,  it is resolved. 

Thanks.

[v-lid-msft]

Hi @Anonymous ,

Glad to hear that you have resolved your problem. Could you sharing the solution you used in this scenario, if it does not contain any confidential information,  so that it can benefit more users in forum? Thanks in Advance.

Best regards,

[amitchandak]

Have you tried liked

IF(ISFILTERD(Table[id]),VALUE(Table[Date]),blank())

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution.
In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blogs -Decoding Direct Query - Time Intelligence, Winner Coloring on MAP, HR Analytics, Power BI Working with Non-Standard TimeAnd Comparing Data Across Date Ranges
Proud to be a Datanaut Connect on Linkedin