Detect missing parameters in DAX queries
Yesterday I answered to a question related to parameters in DAX that could be useful to other readers who use DAX in Reporting Services (SSRS): how to manage missing parameters of a DAX query?
I wrote an article in the past describing how to use parameters in a DAX query, but what is not intuitive is that parameters are always strings. Thanks to automatic conversion of data type in DAX, a string can be easily converted into a number, so you do not see any difference until you have to manage the missing value. You might think that the missing value is passed as a blank, but this is not the case. For example, consider the following DAX query.