Forum Discussion
Calculating Product Attachment Rates
Hi amitchandak ,
Turning of the filter interaction opens up all my product revenue making the product filter not do anything. What I want to be able to do is when filtering on a specific product to not only calculate and show revenue on that product but calculate additional product revenue and show those specific products revenue when on the same orders as the product filtered. I have a measure that calculates the total revenue regardless when that product was used but it doesn't breakout or show other products it just shows total revenue on that one product line. Examples:
I want something like this when product A is filtered
| Product | Q1 | Q2 | Q3 | Q4 |
| A | 1,000 | 1,500 | 2,000 | 3,500 |
| B | 500 | 750 | 1,000 | 2,000 |
| C | - | 250 | 500 | 1,000 |
| D | 500 | 250 | - | - |
| Total | 2,000 | 2,750 | 3,500 | 6,500 |
This is my current state when product A is filtered (just shows the total revenue but not the product mix)
| Product | Q1 | Q2 | Q3 | Q4 |
| A | 2,000 | 2,750 | 3,500 | 6,500 |
Thanks,
Chris
Hi chudson ,
Based on your description, I am not very clear about your scenario.
Could you share the sample pbix via cloud service like onedrive for business?
Please remove any sensitive data before uploading.
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.