Conditional slabs dax

[Zozozop]

YoY_Slab_Column_2 =
SWITCH(
TRUE(),
DimCalendar[YoY growth] > 0, "+ve",
AND(DimCalendar[YoY growth] <= 0, DimCalendar[YoY growth] > -10), "-ve slab 1",
AND(DimCalendar[YoY growth] <= -10, DimCalendar[YoY growth] > -50), "-ve slab 2",
DimCalendar[YoY growth] <= -50, "-ve slab 3"
)

Basically I want to calculate the degrowth from 0 to -10 , -11 to -50 and -50 and above, else I want to calculate growth >0 how can I do this with dax , I already have a yoy growth measure

[amitchandak]

@Zozozop , You need create YoY_Slab_Column_2  as measure not column.

so you will have to measure YoY_Slabs

Have a table with all values you used in this measure using enter date

Then Using a group by this measure creates a new measure

Sumx( Bucket, calculate( CountX(filter(Values(Table[Column]) , [YoY_Slabs] = Max(Bucket[Bucket]) ), [Column])  ) )

Dynamic Segmentation Bucketing Binning
https://community.powerbi.com/t5/Quick-Measures-Gallery/Dynamic-Segmentation-Bucketing-Binning/m-p/1...

Dynamic Segmentation, Bucketing or Binning: https://youtu.be/CuczXPj0N-k

[Zozozop]

YoY growth is a  measure that I've created , will I have to create a calculated column for it to work?