Calculate from Slicer/Filter to Table with final total?

[AnneLafs]

I am trying to create an interactive price model/guide. I have a slicer that is groups where the user can select an item, and the table to the right returns the items selected with a total. This is working.

I'd like them to be able to use the slicer, select a quantity for each and return a summarized total. Is this even possible? I am new to Power BI, so help is very much appreciated. 

 

[AnneLafs]

Thank you!

[collinq]

Hey @AnneLafs ,

I am not sure I understand what you mean when you state "select the quantity"?  If you want them to pick a certain quantity you could add that to the existing hierarchy.  Or, if you mean you want them to pick what the Sum would be based ona  certain number then you should make another slicer with the optoins for the quantity and have a custom field that calculates the sum based on the price you know and the quanity that they seelct.

[AnneLafs]

HI Collinq - thanks for this info. I want them to pick an item from the first slicer. Then I can add another slicer with a quantity (1-5), then the table should result the item, quantity, and total price. That is what I am looking to do.  I am not sure how to tie the slicer for quantity to the slicer to pick the item.

[Anonymous · Accepted solution]

Hi @AnneLafs 

The solution I can think of at the moment is to create a Quantity table and establish a "one-to-many" relationship with the Price table. Then create a "TotalPrice" measure.

TotalPrice = Quantity[Quantity] * RELATED('Price'[Price])

Drag “Item” “Description” and “Quantity” into the slicer visual.

I hope this helps.

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