Looking to compare the sales of two products. I want to be able to compare the total and average unit sales for stores that sell Product A only, stores that sell Product B only, and stores that sell both Product A and B. I am stuck determining the best custom measure that can filter for both the store and the product. Any insight?
I also wanted to see the distinct count of stores that sell each product and successfully wrote a customer measure for stores that sell Product A only and Product B only, but the function did not work when I tried to filter for both in one measure:
"Count of A & B Stores = CALCULATE(DISTINCTCOUNT('Portal Data'[Store]),FILTER('Portal Data',[Description]="SAUERKRAUT A" && [Description]="SAUERKRAUT B"))
How did I go wrong here? The card read the measure as Blank.
Thanks for helping us become Power BI Wizards!