Forum Discussion

PatrickMcLeanGL's avatar
PatrickMcLeanGL
Frequent Visitor
1 year ago
Solved

How to use SELECTEDVALUE for multiple values selection?

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.  
Need Help
  • ExcelMonke's avatar
    ExcelMonke
    1 year ago

    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. 

Anonymous's avatar
Anonymous
Not applicable
1 year ago

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.