How to use SELECTEDVALUE for multiple values selection?

[PatrickMcLeanGL]

I am trying to get my card visual to display a sum of the selected values in the slicer but its throws a blank if I select more than one name.

[Anonymous]

Hi @PatrickMcLeanGL,

Thanks for reaching out to the Microsoft fabric community forum.

It looks like you are trying to finda way to display the sum of selected values using card visual. As @PatrickMcLeanGL already responded to your query, kindly go through his response and check if it solves your issue. 

I would also take a moment to thank @ExcelMonke, for actively participating in the community forum and for the solutions you’ve been sharing in the community forum. Your contributions make a real difference.

If I misunderstand your needs or you still have problems on it, please feel free to let us know.  

Best Regards,
Hammad.
Community Support Team

If this post helps then please mark it as a solution, so that other members find it more quickly.

Thank you.

[ExcelMonke · Accepted solution]

Hello,

You can consider removing the whole calculate & selectedvalue clauses in your measure (unless I'm missing something you are trying to achieve). Basically, you'll just have the following DAX:

New Paid Measure = 
SUM('glx ADP Hours'[Hours])

As long as your models are set up correctly (i.e. the names list is a dim connected/a field in your fact table) and the slicer is interacting with the card, it should sum for only the names you are selecting.