Making a personal selective items and show the total

[Anonymous]

Hello!
So I have a really ambitious thing that I want to try to do in Power BI.
Based on the table here under:

Product	Price	Slicer 1	Slicer 2	Slicer 3
A	10	1	1	1
B	25	1	1	1
C	30	1	1	1
D	45	1	1	1

What I want to do is have a 3 Slicer (or three other visuals that I can Select) with my products and then multiply them and see the total Price of It.

For example:

Slicer 1 = Select Product A and B
SLicer 2 = Select Product A (I need Product A count it 2 times).

And when I Sum them, it give me a total of 45( (10 * 2) + (25)),
I will just need no more that 4 slicers for this, thats why I choose this type of Format of table.

Basically looks like and What-if Analysis, but in my understanding the What-If-Analysis works in the entire column, and is not customable for each row.

Thanks!

[Gubiru]

Hi

I hope it helps

Slicers

If you need some special help, try visit https://www.gubiru.com/

or contact me.

[Anonymous]

Thank You So much!

That was really a smart and elegant way of solving it!

But there is a little issue.. I Have hundreds of Products, and their names are always changing (Some products come in and other products sotck out), How could we figure it out then?

Thank you!