topic Re: SELECTEDVALUE question in DAX Commands and Tips

SELECTEDVALUE question

lhall37122 — Tue, 22 Oct 2024 19:40:13 GMT

Not sure why this is giving me fits but have stared at it long enough and need input. Simply trying to build a measure that determines if the endDate of a record is after the value selected in the Start of Month slicer. The slicer is based on a disconnected date table and just to test was trying to return the value of the slicer in my visual. But its not finding a value so returning the default date of today. What am I missing ???

Re: SELECTEDVALUE question

lbendlin — Tue, 22 Oct 2024 21:03:49 GMT

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

Do not include sensitive information. Do not include anything that is unrelated to the issue or question.

Need help uploading data? https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216

Please show the expected outcome based on the sample data you provided.

Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

Re: SELECTEDVALUE question

Anonymous — Wed, 23 Oct 2024 01:47:54 GMT

Hi lhall37122 ,

Based on the description, try to check the start of month column in the slicer visual and verify the start of month column date type.

The DAX formula should display the slicer's date correctly.

Best Regards,

Wisdom Wu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Re: SELECTEDVALUE question

lhall37122 — Wed, 23 Oct 2024 15:29:30 GMT

Thanks for the reply I can confirm that my "Start Of Month" is set as a DATE data type and looking at your sample .pbix file I can find any difference in my test measure vs yous so completely at a loss why the slicer value will not show correctly.

Re: SELECTEDVALUE question

Anonymous — Tue, 29 Oct 2024 09:28:59 GMT

Hi lhall37122 ,

Based on the description, the error is that the measure DAX formula is not detecting the date selected by the slicer.

So, check that drag the start of month column to the slicer visual and check if a filter is applied.

Besides, creating a new blank report and copy the table data to the new report. Then, drag the start of month to the slicer visual in the new report.

Best Regards,

Wisdom Wu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.