Forum Discussion

GJA's avatar
GJA
Helper II
5 years ago
Solved

DAX Dynamic segmentations

Hi, 

 

I'm trying to make slicers allowing the user to choose segmentations of purchases. For example I have 3 categories. 

I would like that the user can dynamically choose category 1 goes from 0 to 10, category 2 from 11 to 20 and category 3 from 21 to Max value....

 

I tried to make :

- category 1 = Generateseries( 0 , max(Purchases[Value]) , 1 ) 

- category 2 = Generateseries( max(category 1[Value]) , max() , 1 ) 

...

but unfortunately it doesn't work. The category 2 doesn't move dynamically when I slice the category 1.

 

Thanks for your help.