CONTEXT("View") not operating as expected

I’m needing to update key expressions to improve performance in an app. Based on my reading here, the recommendation is to include CONTEXT in the more expensive expressions. A requirement would need to be met before the calculations is completed, reducing the overall sync time. I’ve attempted the following expression and although the correct view is active the data is not appearing at all.

I’m not getting any errors but wondered if the expression is incorrect?

IF(
OR(CONTEXT(“View”)=“chart_quotes_by_sales”,CONTEXT(“View”)=“dash_administrator”),

Sum(
SELECT(Quote Header[vir_total_price],
AND([Status]=“Active”,[_THISROW].[Email]=[Assigned to],[vir_total_price]>0,[Quote Date]>=EOMONTH(Today(), -1)+1,[Quote Date]<=EOMONTH(Today(), 0))
)),

“”)

0 18 512
18 REPLIES 18
Top Labels in this Space