Group slicer

[Anonymous]

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 

[Anonymous · Accepted solution]

got it!

Just need to insert "countrows"