Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
Hey there;
I have an issue, I need that the measure sums only the positive vales
But when I use the switch statement to replane the negatives values with zero, works in the same way when sum the values
What I need is the following result:
I can't do it in a calculated colum because I'm using what-if parameter in the DAX formula.
Solved! Go to Solution.
@Syndicate_Admin,[inven. Sugerido] es una columna
intentan una nueva medida
sumx(Tabla, if(Table[inven. Sugerido] >0, Tabla[inven. Sugerido] , en blanco()))
si [inven. Sugerido] es una medida
sumx(values(Table[material]), if([inven. Sugerido] >0, [inven. Sugerido] , en blanco()))
@Syndicate_Admin,[inven. Sugerido] es una columna
intentan una nueva medida
sumx(Tabla, if(Table[inven. Sugerido] >0, Tabla[inven. Sugerido] , en blanco()))
si [inven. Sugerido] es una medida
sumx(values(Table[material]), if([inven. Sugerido] >0, [inven. Sugerido] , en blanco()))
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!