Forum Discussion
report level filter vs. filter on query
I have a Report Level Filter on a report on my CRM Salesorders, "Name does not contain Cancel". I want to change that so the filter is on the query itself, rather than on the report, but my values change by up to 2K if I do that.
Why does putting the filter on the Query still allow some orders to come through to the report with "Cancel" in the name? Why do I still need the Report Level Filter to filter them all out?
Values with filter on the query:
2016 = 61.57
2017 = 104.91
2018 = 48.49
Values with filter on Report Level Filter
2016 = 59.12
2017 = 103.23
2018 = 48.49
Got it. Power Query is case sensitive. You have given does not contain "Cancel" so records with "Cancel" will filtered, but not "CANCEL". Please use the below formula to make sure all CANCEL/ Cancel gets filtered.
= Table.SelectRows(#"Changed Type", each not Text.Contains(Text.Upper ([Status]), "CANCEL"))