topic SELECTEDVALUE Dax? in DAX Commands and Tips

SELECTEDVALUE Dax?

kylee_anne — Wed, 17 Jan 2024 04:28:28 GMT

Can I pull 3 different selected values with 3 different slicers on the same column of data on one report page? And then use each selected value to filter approx 24 cards?

Can I use SELECTEDVALUE for this? Or should I use something else?

Re: SELECTEDVALUE Dax?

Fowmy — Wed, 17 Jan 2024 05:20:35 GMT

kylee_anne

If you are using three slicers for a single column from a table, then you won't be able to do so as once you filter using the 1st slicer, then, the other two slicers are getting filtered preventing you to select other values. The other point is SELECTEDVALUE always retreives a single values.

I am not sure about your requirment exactly to suggest a solution. Please elaborate it.

Re: SELECTEDVALUE Dax?

kylee_anne — Wed, 17 Jan 2024 05:39:44 GMT

Thanks. What I have is data for a weekly report but heavily sanitized. Report is to qualify hours on construction of a mine shaft in the previous week against total actual and planned. I'd thought I could even use this lot of cards,

pulling from afew tables, using edit interactions to filter set 117 and cards pertaining to it. Thoughts?