What-if in DM DAX Model with slicers

[hansolu]

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

Please Login or Register  to view this content.

even if the ID is not in the pivot table


Measure used:

Please Login or Register  to view this content.

Please Login or Register  to view this content.

I hope my example is easy to understand

thanks a lot