Forum Discussion
Group slicer
Hello!
I want to group my customers by interval of sales
Created a table with 3 columns
Interval Min Max
> 100k 50k 100k
> 50k 10k 50k
> 10k 0 k 10k
And I want to put this info in a slicer, so when I select the interval of customers who bought above 100k ths year I can see all indicators for just that sub group of customers.
I created a measure for that:
Sales Group = CALCULATE([Total Sales TY];
FILTER(VALUES(SALES[Customer_name]);
FILTER(Cohort_Grouping_Sales;
[Total Sales TY] >= Grouping_Sales[Min Sales] &&
[Total Sales TY] < Grouping_Sales[Max Sales])
)
However the result its not filtering the group, and I keep getting the total sales, and not the sum of sales for customers in the interval.
Thanks