Forum Discussion
Solved
Calculate from Slicer/Filter to Table with final total?
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 w...
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.
Thank you!