Hi,
I have a large set of sales data and I want to analyse if customers (retail stores) who purchased a product boundle performed better in the products in that boundle or similar products in the following weeks after placing the boundle in the store.
In other words I would like to group customers who bought boundles within a category in one group and the rest in another and then analyse wether there is a significant uplift of displaying a boundle. I want a binomial slicer function that lets me filter the boundle-purchasers vs. the non-boundle-purchaser. I have made a binomial measure highlighting the customers that purchased a boundle the last 4 weeks (1) and those that did not (0). This measure is dynamic within the different categories and weeks of my data (so a customer pops in and out of (1) given the weeks and the product category I look at.
If I could have just popped that measure into a slicer or as a legend in a graph I would be a happy man, but I can't figure out how I could either filter on this measure (or "slice" on it) or use it to create two new measures with one measure giving the sales performance of boundle buyers and the other giving the sales performance of non-boundle buyers.
I found this thread with a similar issue, but the solution does not work for me.
https://community.powerbi.com/t5/Desktop/Cannot-use-measure-in-slicer/td-p/166909?lightbox-message-i...
Any ideas how I might get around this problem?
Thanks in advance
