Forum Discussion
Add an IF within a variable
Hello everyone!!! I am performing the following measurement in dax: CALCULATION = VAR OPERATION = calculate( SUM(Table1[amount]), ...
You cannot return a text string or a number in the same measure. All results need to be of the same type (or BLANK). Change your measure to return BLANK instead of NC, or convert all output to text.