Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

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

Reply
Zozozop
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
amitchandak
Super User
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

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

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

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

MayPowerBICarousel

Power BI Monthly Update - May 2024

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

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.