Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Scatter Chart Ignoring Visual Level Filter Measure

I am having an issue with Scatter Chart's (Standard Visual and custom from marketplace) ignoring the Visual Level Filter measure in place, causing a 1,000,000 row limit error for a single visual usin...
Need Help
jtownsend21's avatar
jtownsend21
Responsive Resident
7 years ago

I believe your statement "It is as if Power BI tries to pull in all the data first" is correct. 

The if statement evaluates each line, try a switch function. That fixed a similar issue I had before. 

Try something like this: 

 

Switch( TRUE(), [Distance] <= MAX('Distance'[Distance Away]),1,0)
Anonymous's avatar
Anonymous
Not applicable
7 years ago

I am receiving the same 1M row errror with the SWITCH function as I am with an IF statement.  I am also receiving the error when charting the same Depth and Value combo in a line chart.  How do I get Power BI or a DAX statement to filter the data and avoid this error?

 

In DAX studio, if I am interpreting this correctly, I am seeing that the query actualy ignores the Measure used to filter the data on the inner query.  Then tries to apply it on the outer query, but throws a 1M row error before it can filter the results.