I’m trying to create a measure of SUM my Net Sales and combine with a What-if parameter percentage.
The logic/rule is like this:
I have 2 tables :
Items: ItemID and ItemGroup
Sales: ItemmID and Net Sales, relation is ItemID
Beside the usual What-if parameter of a percentage calculation factor, I also have slicer for ItemGroup.
User will need to select this Item Group, can be multiple value
Then I will display it in a table, contain Item Group, Net sales (original), and the Scenario sales, The net sales will be the Sum value of all the original Net sales whereby Scenario Sales, for those selected Item group, it will calculate Sum of Net sales with addition of percentage What-if, the non selected will remain as the original Net sales.
The table interactions, I will put to “not” filtering, so even though user select 2 or 3 Item group, the table will display all item group (with no 4. rule)
How would be the Scenario sales measure looks like ?