Forum Discussion
BQ - Direct Query 1 million row limit
The only other thing I could think to try is to force the calculation of both measures in the hope that that will enable Power BI to pass the filter to BigQuery like it does when you call a simple measure.
You could either use IF.EAGER or rewrite the code using variables like
Measure3 = VAR Measure1 = [Measure1] VAR Measure2 = [Measure2] RETURN IF ( SELECTEDVALUE ( NewTable[field] ) = "Cost", Measure1, Measure2 )Performance isn't going to be good, but then I would think that performance will already be so slow that you may not notice the difference.
I can't use a field parameter because [Measure3] is used by multiple measures (10).
If I use a field parameter, I can change [Measure1] and [Measure2] dynamically in the visual. However, this would require me to duplicate the 10 measures, resulting in 20 measures in total. I feel this is redundant. That’s why I didn’t prefer using field parameters and bookmarks.
The only other thing I could think to try is to force the calculation of both measures in the hope that that will enable Power BI to pass the filter to BigQuery like it does when you call a simple measure.
You could either use IF.EAGER or rewrite the code using variables like
Measure3 =
VAR Measure1 = [Measure1]
VAR Measure2 = [Measure2]
RETURN
IF ( SELECTEDVALUE ( NewTable[field] ) = "Cost", Measure1, Measure2 )
Performance isn't going to be good, but then I would think that performance will already be so slow that you may not notice the difference.