Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.