Hi,
I do have a kind of What-if problem I want to solve. My solution is working for a single selection of an ID number but not for multiple selections. Anyone has an idea how I need to modify my formula to be able to use multiple ID to apply the discount from the discount slicer?
Background:
Sales table where I want to apply a percentage to calculate new sales values based on the percentage.
I created two helper tables in PQ and use them to select the discount level for a selected partnumber.
Problem:
I can only choose one partnumber (=ID) to apply. The ID also need to be in the row of the pivot chart so my formula is working. I know that my formula is wrong as its is designed for one value,but I dont know how to modify to apply for multiple selection
What I want:
Select 1 or 2 or 3 ID and apply the discount to all of the selected ID
Be able to use the measure
even if the ID is not in the pivot table
Measure used:
I hope my example is easy to understand
thanks a lot
Bookmarks