I have a report with an SAP HANA DirectQuery source. I have a column with text that has values like '0000000ABCD'. I add a Report level filter with the condition "Is not blank" for this column. I display this on a table visual and it shows correctly. When I create a calculated column with the formula
Col No Zero = SUSBSTITUTE([my text column], "0", "")
and add this column to the table visual, the table visual no longer displays the data correctly. Col No Zero is populated, but the original text column now shows many blanks, and the few values that do show up do not match the Col No Zero values in any way.