cancel
Showing results for
Did you mean:

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Frequent Visitor

## 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 2
Super User

@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

Frequent Visitor

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

Announcements

#### New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

#### Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

#### Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors
Top Kudoed Authors