Parameters in Report Builder (DAX query copied from Performance Analyzer)

Experiment with the DAX query editor by adding removing parameters. This looks like a reasonable article: https://www.mssqltips.com/sqlservertip/5865/sql-server-reporting-services-report-builder-with-dax-query-support/

Hi folks... I was able to get parameters to work a variable like:

VAR __DS0FilterTable5 = 
    TREATAS({@paramCropYear}, 'Planted Crop'[CropYear])

DEFINE
 VAR__DS0FilterTable5 = 
    TREATAS({@paramCropYear}, 'Planted Crop'[CropYear])

  VAR __DS0Core = 
    SUMMARIZECOLUMNS(
      ROLLUPADDISSUBTOTAL(
        ROLLUPGROUP(
          'Planted Crop'[CropYear],
          'Planted Crop'[Farm],
          'Planted Crop'[Variety],
          'Planted Crop'[Field]
        ), "IsGrandTotalRowTotal"
      ),
      __DS0FilterTable5,
      "Target_Seed_Spacing", 'Planter Evaluation'[Target Seed Spacing],
      "Projected_Spacing", 'Planter Evaluation'[Projected Spacing],
      "Spacing____", 'Planter Evaluation'[Spacing +/-],
      "Target_Plant_Population", 'Planter Evaluation'[Target Plant Population],
      "Projected_Plant_Population", 'Planter Evaluation'[Projected Plant Population],
      "Plant_Population_Observed_vs__Target", 'Planter Evaluation'[Plant Population Observed vs. Target],
      "Ideal_Seed_Placement__", 'Planter Evaluation'[Ideal Seed Placement %],
      "Double_Seed_Placement__", 'Planter Evaluation'[Double Seed Placement %],
      "Skip_Seed_Placement__", 'Planter Evaluation'[Skip Seed Placement %],
      "Exact_Seed_Placement__", 'Planter Evaluation'[Exact Seed Placement %]
    )

  VAR __DS0PrimaryWindowed = 
    TOPN(
      502,
      __DS0Core,
      [IsGrandTotalRowTotal],
      0,
      'Planted Crop'[CropYear],
      1,
      'Planted Crop'[Farm],
      1,
      'Planted Crop'[Variety],
      1,
      'Planted Crop'[Field],
      1
    )

EVALUATE
	FILTER(__DS0PrimaryWindowed, 'Planted Crop'[CropYear] >2000)

ORDER BY
  [IsGrandTotalRowTotal] DESC,
  'Planted Crop'[CropYear],
  'Planted Crop'[Farm],
  'Planted Crop'[Variety],
  'Planted Crop'[Field]

Hi - I am kind of in the similar scenario copying the query generated from Performance Analyzer. However it is restricting the number of records to 501 (TOPN function). When I delete it, I get an error Query Preparation Failed - The end of the input was reached(Microsoft Analysis Services). What am I doing icorrectly here? Am I deleting more than what should be deleted? If so please point out what has to be removed from the query below so it fetches all the existing records.

Thanks!!!

Query copied from Performance Analyzer. I have deleted the entire TOPN function (colored in red).

// DAX Query
DEFINE
VAR __DS0Core =
SELECTCOLUMNS(
KEEPFILTERS(
FILTER(
KEEPFILTERS(
SUMMARIZECOLUMNS(
'Query1'[Invoice_Complete],
'Query1'[Invoiced_Quantity],
'Query1'[Staples_order_no],
'Query1'[Staples_return_order_no],
'Query1'[return_status_description],
'Query1'[customer_name],
'Query1'[External_Document_No],
'Query1'[Our_Item_No],
'Query1'[EXTERNAL_ITEM_NO],
'Query1'[Return_Node],
'Query1'[Create_date],
'Query1'[return_create_date],
'Query1'[return_date_plus18days],
'Query1'[Open_days],
'LocalDateTable_fd4ab7aa-4e0a-4c2f-baeb-1a0197162a03'[Year],
'LocalDateTable_fd4ab7aa-4e0a-4c2f-baeb-1a0197162a03'[Quarter],
'LocalDateTable_fd4ab7aa-4e0a-4c2f-baeb-1a0197162a03'[QuarterNo],
'LocalDateTable_fd4ab7aa-4e0a-4c2f-baeb-1a0197162a03'[Month],
'LocalDateTable_fd4ab7aa-4e0a-4c2f-baeb-1a0197162a03'[MonthNo],
'LocalDateTable_fd4ab7aa-4e0a-4c2f-baeb-1a0197162a03'[Day],
"CountRowsQuery1", CALCULATE(COUNTROWS('Query1'))
)
),
OR(
OR(
OR(
OR(
OR(
OR(
OR(
OR(
OR(
OR(
OR(
OR(
OR(
OR(
OR(
OR(
OR(
OR(
OR(
NOT(ISBLANK('Query1'[Invoice_Complete])),
NOT(ISBLANK('Query1'[Invoiced_Quantity]))
),
NOT(ISBLANK('Query1'[Staples_order_no]))
),
NOT(ISBLANK('Query1'[Staples_return_order_no]))
),
NOT(ISBLANK('Query1'[return_status_description]))
),
NOT(ISBLANK('Query1'[customer_name]))
),
NOT(ISBLANK('Query1'[External_Document_No]))
),
NOT(ISBLANK('Query1'[Our_Item_No]))

),
NOT(ISBLANK('Query1'[EXTERNAL_ITEM_NO]))
),
NOT(ISBLANK('Query1'[Return_Node]))
),
NOT(ISBLANK('Query1'[Create_date]))
),
NOT(ISBLANK('Query1'[return_create_date]))
),
NOT(ISBLANK('Query1'[return_date_plus18days]))
),
NOT(ISBLANK('Query1'[Open_days]))
),
NOT(ISBLANK('LocalDateTable_fd4ab7aa-4e0a-4c2f-baeb-1a0197162a03'[Year]))
),
NOT(ISBLANK('LocalDateTable_fd4ab7aa-4e0a-4c2f-baeb-1a0197162a03'[Quarter]))
),
NOT(ISBLANK('LocalDateTable_fd4ab7aa-4e0a-4c2f-baeb-1a0197162a03'[QuarterNo]))
),
NOT(ISBLANK('LocalDateTable_fd4ab7aa-4e0a-4c2f-baeb-1a0197162a03'[Month]))
),
NOT(ISBLANK('LocalDateTable_fd4ab7aa-4e0a-4c2f-baeb-1a0197162a03'[MonthNo]))
),
NOT(ISBLANK('LocalDateTable_fd4ab7aa-4e0a-4c2f-baeb-1a0197162a03'[Day]))
)
)
),
"'Query1'[Invoice_Complete]", 'Query1'[Invoice_Complete],
"'Query1'[Invoiced_Quantity]", 'Query1'[Invoiced_Quantity],
"'Query1'[Staples_order_no]", 'Query1'[Staples_order_no],
"'Query1'[Staples_return_order_no]", 'Query1'[Staples_return_order_no],
"'Query1'[return_status_description]", 'Query1'[return_status_description],
"'Query1'[customer_name]", 'Query1'[customer_name],
"'Query1'[External_Document_No]", 'Query1'[External_Document_No],
"'Query1'[Our_Item_No]", 'Query1'[Our_Item_No],
"'Query1'[EXTERNAL_ITEM_NO]", 'Query1'[EXTERNAL_ITEM_NO],
"'Query1'[Return_Node]", 'Query1'[Return_Node],
"'Query1'[Create_date]", 'Query1'[Create_date],
"'Query1'[return_create_date]", 'Query1'[return_create_date],
"'Query1'[return_date_plus18days]", 'Query1'[return_date_plus18days],
"'Query1'[Open_days]", 'Query1'[Open_days],
"'LocalDateTable_fd4ab7aa-4e0a-4c2f-baeb-1a0197162a03'[Year]", 'LocalDateTable_fd4ab7aa-4e0a-4c2f-baeb-1a0197162a03'[Year],
"'LocalDateTable_fd4ab7aa-4e0a-4c2f-baeb-1a0197162a03'[Quarter]", 'LocalDateTable_fd4ab7aa-4e0a-4c2f-baeb-1a0197162a03'[Quarter],
"'LocalDateTable_fd4ab7aa-4e0a-4c2f-baeb-1a0197162a03'[QuarterNo]", 'LocalDateTable_fd4ab7aa-4e0a-4c2f-baeb-1a0197162a03'[QuarterNo],
"'LocalDateTable_fd4ab7aa-4e0a-4c2f-baeb-1a0197162a03'[Month]", 'LocalDateTable_fd4ab7aa-4e0a-4c2f-baeb-1a0197162a03'[Month],
"'LocalDateTable_fd4ab7aa-4e0a-4c2f-baeb-1a0197162a03'[MonthNo]", 'LocalDateTable_fd4ab7aa-4e0a-4c2f-baeb-1a0197162a03'[MonthNo],
"'LocalDateTable_fd4ab7aa-4e0a-4c2f-baeb-1a0197162a03'[Day]", 'LocalDateTable_fd4ab7aa-4e0a-4c2f-baeb-1a0197162a03'[Day]
)

VAR __DS0PrimaryWindowed =
TOPN(
501,
__DS0Core,
'Query1'[External_Document_No],
1,
'Query1'[Invoice_Complete],
1,
'Query1'[Invoiced_Quantity],
1,
'Query1'[Staples_order_no],
1,
'Query1'[Staples_return_order_no],
1,
'Query1'[return_status_description],
1,
'Query1'[customer_name],
1,
'Query1'[Our_Item_No],
1,
'Query1'[EXTERNAL_ITEM_NO],
1,
'Query1'[Return_Node],
1,
'Query1'[Create_date],
1,
'Query1'[return_create_date],
1,
'Query1'[return_date_plus18days],
1,
'Query1'[Open_days],
1,
'LocalDateTable_fd4ab7aa-4e0a-4c2f-baeb-1a0197162a03'[Year],
1,
'LocalDateTable_fd4ab7aa-4e0a-4c2f-baeb-1a0197162a03'[QuarterNo],
1,
'LocalDateTable_fd4ab7aa-4e0a-4c2f-baeb-1a0197162a03'[Quarter],
1,
'LocalDateTable_fd4ab7aa-4e0a-4c2f-baeb-1a0197162a03'[MonthNo],
1,
'LocalDateTable_fd4ab7aa-4e0a-4c2f-baeb-1a0197162a03'[Month],
1,
'LocalDateTable_fd4ab7aa-4e0a-4c2f-baeb-1a0197162a03'[Day],
1
)

EVALUATE
__DS0PrimaryWindowed

ORDER BY
'Query1'[External_Document_No],
'Query1'[Invoice_Complete],
'Query1'[Invoiced_Quantity],
'Query1'[Staples_order_no],
'Query1'[Staples_return_order_no],
'Query1'[return_status_description],
'Query1'[customer_name],
'Query1'[Our_Item_No],
'Query1'[EXTERNAL_ITEM_NO],
'Query1'[Return_Node],
'Query1'[Create_date],
'Query1'[return_create_date],
'Query1'[return_date_plus18days],
'Query1'[Open_days],
'LocalDateTable_fd4ab7aa-4e0a-4c2f-baeb-1a0197162a03'[Year],
'LocalDateTable_fd4ab7aa-4e0a-4c2f-baeb-1a0197162a03'[QuarterNo],
'LocalDateTable_fd4ab7aa-4e0a-4c2f-baeb-1a0197162a03'[Quarter],
'LocalDateTable_fd4ab7aa-4e0a-4c2f-baeb-1a0197162a03'[MonthNo],
'LocalDateTable_fd4ab7aa-4e0a-4c2f-baeb-1a0197162a03'[Month],
'LocalDateTable_fd4ab7aa-4e0a-4c2f-baeb-1a0197162a03'[Day]