Hello,
I have a table that contains various products, all identified by a unique Product ID. This table can be filtered using slicers, by either Product ID, or Product Description. However, some items may have the same description, although the Product ID remains unique. I have costs for each product showing in each row of the table, and I need to add a formula to show a discounted price if more than 1 unique Product ID is contained within the table (based on the filtered slicer selection).
For example, if someone uses the slicers to filter down the table to 1 product, they will see the product attributes in separate columns, followed by a column for the full price of that item. If they select multiple products via the slicers, then a set % discount needs to be applied to each row, and shown in its own column along with a grand total.
I've been able to use a measure to add a column showing the discount % to apply as follows:
DiscountPct = CALCULATE(DISTINCTCOUNT('ProductPricing'[ProductId]),ALLSELECTED('ProductPricing'))
Now ideally, I'd be able to create a new column to multiply this DiscountPct measure by each row, but when I do that, the calculated column doesn't update with each selection within the slicers.
Any suggestions on the best way to accomplish this? Here are 2 examples of tables to show what the expected behavior should be, the Discounted Price column is the one I'm unable to get working:
1 unique product ID value selected by the slicers:
| Product ID | Product Description | Original Price | Multiple Part Discount | Discounted Price |
| P100 | Part 100 | $100.00 | 0% | $100.00 |
| Total: | | $100.00 | 0% | $100.00 |
More than 1 unique Product ID selected:
| Product ID | Product Description | Original Price | Multiple Part Discount | Discounted Price |
| P100 | Spare Part | $100.00 | 10% | $90.00 |
| P101 | Another Spare Part | $125.00 | 10% | $112.50 |
| P102 | Some Other Spare Part | $50.00 | 10% | $45.00 |
| P103 | Spare Part | $75.00 | 10% | $67.50 |
| Total: | | $350.00 | 10% | $315.00 |
