Forum Discussion
Solved
Problems using SUMX, FILTER, and VALUE together
Taking a different approach to a problem I posted about yesterday. I'm trying to create a measure that I can use to flag types of coding changes based on the measure results. The codes are stored...
I ended up creating a calculated column that returns blank values for rows where there were letters in the codes. I end up with several "undefined" cases but still far better than doing everything manually, which is the current state.
Hi cathoms , have your tried using a calculated column with an if statement to set the alphanumerics as 0. I tried it there on a DQ I have, it's not alphamumeric but it worked. In the above you are using an OR clause with the || should this not be AND() or &&?
I ended up creating a calculated column that returns blank values for rows where there were letters in the codes. I end up with several "undefined" cases but still far better than doing everything manually, which is the current state.