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

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.

Reply
Caraneda
Frequent Visitor

OR conditional in DAX

Hi, 
I've the following measure, but I'll like to know how can I change the  "Consulta1[Rentabilidad] <> 0 " condition to less than -0.01 or bigger than 0.01.

 

Date1: =

VAR currentnemo =

    MAX ( Consulta1[nemotecnico] )

VAR summarize_table =

    FILTER (

        SUMMARIZE ( ALL ( Consulta1 ), Consulta1[fecha], Consulta1[nemotecnico], Consulta1[Rentabilidad] ),

        Consulta1[nemotecnico] = currentnemo

            && Consulta1[Rentabilidad] <> 0 

    )

VAR newtable =

    ADDCOLUMNS (

        summarize_table,

        "@daterank", CALCULATE ( RANKX ( summarize_table, CALCULATE ( MAX ( Consulta1[fecha] ) ),, ASC ) )

    )

VAR filternewtable =

    FILTER ( newtable, [@daterank] = 1 )

RETURN

    IF ( HASONEVALUE ( Consulta1[nemotecnico] ), MAXX ( filternewtable, Consulta1[fecha] ) )

 

 

Thanks!

1 ACCEPTED SOLUTION
smpa01
Super User
Super User

@Caraneda 

&& Consulta1[Rentabilidad] < 0.01 || Consulta1[Rentabilidad] > 0.01
Did I answer your question? Mark my post as a solution!
Proud to be a Super User!
My custom visualization projects
Plotting Live Sound: Viz1
Beautiful News:Viz1, Viz2, Viz3
Visual Capitalist: Working Hrs

View solution in original post

1 REPLY 1
smpa01
Super User
Super User

@Caraneda 

&& Consulta1[Rentabilidad] < 0.01 || Consulta1[Rentabilidad] > 0.01
Did I answer your question? Mark my post as a solution!
Proud to be a Super User!
My custom visualization projects
Plotting Live Sound: Viz1
Beautiful News:Viz1, Viz2, Viz3
Visual Capitalist: Working Hrs

Helpful resources

Announcements
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.