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

Get certified as a Fabric Data Engineer: Check your eligibility for a 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700. 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
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

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