Forum Discussion
Conditional slabs dax
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, DimCal...
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/1387187#M626
Dynamic Segmentation, Bucketing or Binning: https://youtu.be/CuczXPj0N-k
YoY growth is a measure that I've created , will I have to create a calculated column for it to work?