Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
4 years ago

Add an IF within a variable

Hello everyone!!! I am performing the following measurement in dax: CALCULATION = VAR OPERATION = calculate( SUM(Table1[amount]), ...
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
4 years ago

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.