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 ...
Re the effect of setting the variables using assigned strings I said:
"It doesn't seem to persist if I manually set the strings. Something strange is happening in the queries that set Condition1 & Condition2 but I can't figure out how or why changing the output values for the conditions should have any effect on the expressions that are evaluated in conditional statements, nor on the expressions that set the variables."
Thanks for your time and patience trying to explain this for me. At the end of the day I don't think the answer is needed in order for me to design a working solution but I just find it weird and weird bugs me.