Your approach using calculated measures is a good one when a single measure is selected.
Unfortunately, I don't think it is possible to enable multiple selections. In my opinion, the inability to easily select data items in prompts is a shortcoming in our product.
In VA 8.4 and later, you can enable your report consumers to change the data assignments for your report objects. This is very powerful for users who want to deep dive into the data, but it is less suitable to more casual users and when it is undesirable to enable this (when there are data privacy concerns, for example.)
There is a Ballot Idea for what you want to do, and you may want to add some comments to it:
Hi! What you can do is to transform your data (befre loading it into VA) and create a new dimension containing the name of the measure and a new measure containing the value. You then group your chart by the new dimension and filter it with a list object containing the new dimension. As value in the bar chart you use the new measure. //Fredrik
Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.
If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website.