Forum Discussion

jgray72's avatar
jgray72
Helper II
6 years ago

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

Hi - I'm building my first report in Power BI Report Builder and followed instructions to copy my query from Performance Analyzer.  The query works as expected and it' s a huge time saver to copy it ...
Need Help
dsandberg's avatar
dsandberg
Advocate I
5 years ago

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]