Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
afrutos
Resolver I
Resolver I

If not working

‎02-24-2022 02:18 AM

Hello everyone, 
I have this table, with my measures
and everything is working fine except the if function,
I would like to have: if my column "ComprobacioD" is 0 then is completed otherwise is Incomplete.

But it's not working.
Can anybody help me?
Thanks

 

afrutos_0-1645697859399.png

 

Labels:
Message 1 of 4
588 Views
0
1 ACCEPTED SOLUTION
AllisonKennedy
Super User
Super User

‎02-24-2022 02:24 AM

@afrutos  What's the measure for comprobacioD? Is it possible that it's not exactly 0? Try changing your if to 

 

<0.00000001 and see if that helps, then continue troubleshooting from there.


Please @mention me in your reply if you want a response.

Copying DAX from this post? Click here for a hack to quickly replace it with your own table names

Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C

I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com

View solution in original post

Message 2 of 4
586 Views
3 REPLIES 3
AllisonKennedy
Super User
Super User

‎02-24-2022 02:24 AM

@afrutos  What's the measure for comprobacioD? Is it possible that it's not exactly 0? Try changing your if to 

 

<0.00000001 and see if that helps, then continue troubleshooting from there.


Please @mention me in your reply if you want a response.

Copying DAX from this post? Click here for a hack to quickly replace it with your own table names

Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C

I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com

Message 2 of 4
587 Views
afrutos
Resolver I
Resolver I
In response to AllisonKennedy

‎02-24-2022 02:43 AM
Medida = IF(( [ComprobacioD]>= 0 && [ComprobacioD]< 0.0000000000001 ) , "completada","incompleta")
 
Now it's working !!
 
thank you!
 
Message 4 of 4
553 Views
0
afrutos
Resolver I
Resolver I
In response to AllisonKennedy

‎02-24-2022 02:41 AM

the is the measure for ComprobacioD: 

ComprobacioD = [SUM DIR] - [SUM % Distribucion Obra D]
 

This is working a little bit better but then it should be between 0 and <0.00000001

afrutos_0-1645699279159.png

I'm a little bit lost

 

Message 3 of 4
553 Views
0

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

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.

View All