Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Anonymous
Not applicable

Making a personal selective items and show the total

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

ProductPriceSlicer 1Slicer 2Slicer 3
A10111
B25111
C30111
D45111


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!

2 REPLIES 2
Gubiru
New Member

Hi

 

I hope it helps

 

Slicers

 

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

or contact me.

Anonymous
Not applicable

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!

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.