Forum Discussion
How to use SELECTEDVALUE for multiple values selection?
- 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.
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.