Data Science Wire

Do you pros really do this?

Reddit r/PowerBI1mo5 min read

Today I caught a DAX error around floating number. Basically i was doing a threshold measure for filtering ranked item and the logic explicitly remove negative value before compute but the end result had a few negative item mixing in. It just make zero sense so I set Claude on a hunt and turn out it was computed float error at e-16 decimal. The fix was a simple round(xxx,6) I then ask Claude how do people even hunt down stuff like this to fix them and it told me “seasoned DAX authors know that computed float with <>= is dangerous and always round or add tolerance”. Is this true? I felt so out

Read the full story at Reddit r/PowerBI

More in Analytics Engineering