topic Re: SUM single values from different slicers on different columns in DAX Commands and Tips

SUM single values from different slicers on different columns

PedroPiau — Tue, 31 Jan 2023 21:56:40 GMT

I would like to sum the single values from the two slicers below dynamically. They are from two columns located on same table. I tried to use SELECTEDVALUE but didnt work out, only when the exact same value is selected on both slicers.
I might be aproaching this wrongly, Ive already tried numeric parameters and it did work but the issue is that the original file has more than just two columns to be added up dynamically.

If someone can help me I would be appreciated, thanks

Re: SUM single values from different slicers on different columns

FreemanZ — Tue, 31 Jan 2023 22:14:33 GMT

hi PedroPiau

do you have column2= 3 and column1= 6 combination in your table?

Re: SUM single values from different slicers on different columns

PedroPiau — Fri, 03 Feb 2023 16:51:42 GMT

Sorry for the delay. This is my only table.

Re: SUM single values from different slicers on different columns

FreemanZ — Sun, 05 Feb 2023 04:07:18 GMT

hi PedroPiau

This doesn't make sense. As we can turn off the interactions between visual, but the two columns in a same table are still related.

If you do the same with two columns from two unrelated tables, it shall work as you expect.

Re: SUM single values from different slicers on different columns

PedroPiau — Sun, 05 Feb 2023 15:45:44 GMT

I know this was a solution but if I want to escalate like five, seven columns, i would need five, seven tables. I was think if is there a way I could keep it simple without the need to add the tables?