Calculate a total of selected measures

[JakubV]

Hi,

I have a table with data from which I calculate several measures. Then, in order to put these measures in a waterfall chart, I've created a supporting table with measure name and alternative names. To filter what should be shown in the waterfall chart I then created a slicer which includes the alternative names. So far it works flawlessly.
Now. I need/would like to be able to do 2 things:
1. create a new measure which will calculate a total of the measures that I select in the slicer. Example: I have AltName1, AltName2, AltName3 which are linked to Measure1, Measure2, Measure3. When I select AltName1 and AltName3, I only want a total for these 2 measures (as they show in the Waterfall chart). If I select all, I want it to be a total of all 3 measures.
2. Using the same slicer or even a new one, I would like to use it as a filter in a table visual to only show the "Document nr" for which the selected measure/measures total value is <> 0.
Any ideas?
Thanks.

[Anonymous]

Hi @JakubV ,

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data. We can better understand the problem and help you.

Best Regards,

Clara Gong

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.