If Statement Calculated Column Returning Incorrectly

Hi damilolaA ,

The issue you're encountering is due to a data type mismatch in your Qty column. Power BI is likely interpreting the numbers in that column as Text instead of as a Whole Number. When a DAX formula like 'Table'[Qty] > 3 compares a text value to a number, it doesn't perform a mathematical comparison, which is why every row incorrectly evaluates to FALSE.

The most effective way to solve this is to correct the data type at its source using the Power Query Editor. You can access this by clicking "Transform data" on the Home ribbon. Inside the editor, select the Qty column, right-click the header, choose "Change Type," and then select "Whole Number." After you click "Close & Apply," your original DAX formula will work perfectly without any changes because the column's data is now correctly formatted as a number.

If you are unable to modify the data type in Power Query, you can force the conversion within your DAX formula itself by wrapping the column name in the VALUE() function. This function converts a text string into a number. While this approach works, it is less efficient as the conversion must be performed for every row each time the calculation runs, so fixing the data type in Power Query remains the recommended solution.

is_Qty_Greater_Than_3 = IF(VALUE('Table'[Qty]) > 3, BLANK(), FALSE())

Best regards,