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, 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
2 Replies
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-kYoY growth is a measure that I've created , will I have to create a calculated column for it to work?
