My two tables are many-many. How to make one-many with a slicer?
I have two tables with a common column 'category': A: category, product, price B: category, discount_level, discount_pct Table A has multiple products per category and table B has multiple discount levels per category, so the relationship on category is many-many. Question: How can I calculate price*discount_pct based on a discount level selected by the user in a slicer? Note: I have a solution but it is too slow. The solution is to transpose the discount levels into columns, which makese the category in table B unique, then use SWITCH to choose the correct column. I would like to avoid transpose to see if I can improve the performance. (I believe the performance is slow using transpose because it must calculate discounted prices at every discount level first, then select the correct version according to the user selection using SWITCH.)