Forum Discussion
Solved
Handling NULL values
I have seen many posts and solution re handling NULL values in Power BI but I could not find the solution I am seeking. I have a column with variant data type: Number and NULL. So, this data cannot...
Hi,
The Data type of the column should be decimal and you should not feel the need to replace null with 0. Your visuals should work perfectly. Can you share the file's download link and show the exact problem.
Keep your null values as is in the table and you can create a measure like this to handle NULL Values
_Test = CALCULATE(IF(SUM('Table'[Column2])=BLANK(),0,SUM('Table'[Column2])))
It did not work. Throws below error when tried to display the measure in a key card.