Forum Discussion
M Query filter on Value.FromText
So I have a column that I can't change to number but need to filter based on value. I used the advanced editor to do this and it seems to work in preview, the "values" start where I want, but fai...
Removing the filter does "fix" the error.
The data on the source system has not changed.
It looks like the issue is in your measures; DAX is not really my area of knowledge.
Perhaps you have some incomplete releationships after filtering (1:m becomes 1:0/m or 0/1:m).
Working off your idea I recreated the pbix with just the one query/table and no calculated measures or columns.
I then try to apply my filter and get the error still.
Interestingly, I noticed the columns that are detected as aggregate lose their aggregation with the error applied.