Forum Discussion
DAX weirdness - nested condition changes behaviour based on output string value
I have the following query for a calculated column, which uses variables set by filtering down tables to a single value. These two variables are then used in a two part conditional statement to set ...
Values in DAX are case insensitive, so "Ha" = "ha". My guess is that the value shown for the column will depend on which row is evaluated first, so if the first row evaluates to "ha" then all the others will show as that. I am not sure, though, what order rows are evaluated in when it comes to calculated columns.