query plan

{
  "FileFormatVersion": 1,
  "PhysicalQueryPlanRows": [
    {
      "Records": null,
      "Operation": "PartitionIntoGroups: IterPhyOp LogOp=Order IterCols(0, 1)('covid_19_geographic_distribution_worldwide'[countries_and_territories], ''[Sumdaily_confirmed_cases]) #Groups=1 #Rows=212",
      "IndentedOperation": "PartitionIntoGroups: IterPhyOp LogOp=Order IterCols(0, 1)('covid_19_geographic_distribution_worldwide'[countries_and_territories], ''[Sumdaily_confirmed_cases]) #Groups=1 #Rows=212",
      "Level": 0,
      "RowNumber": 1
    },
    {
      "Records": 1,
      "Operation": "AggregationSpool<Order>: SpoolPhyOp #Records=1",
      "IndentedOperation": "    AggregationSpool<Order>: SpoolPhyOp #Records=1",
      "Level": 1,
      "RowNumber": 2
    },
    {
      "Records": null,
      "Operation": "Proxy: IterPhyOp LogOp=TableVarProxy IterCols(0, 1)('covid_19_geographic_distribution_worldwide'[countries_and_territories], ''[Sumdaily_confirmed_cases])",
      "IndentedOperation": "        Proxy: IterPhyOp LogOp=TableVarProxy IterCols(0, 1)('covid_19_geographic_distribution_worldwide'[countries_and_territories], ''[Sumdaily_confirmed_cases])",
      "Level": 2,
      "RowNumber": 3
    },
    {
      "Records": null,
      "Operation": "Proxy: IterPhyOp LogOp=TableVarProxy IterCols(0, 1)('covid_19_geographic_distribution_worldwide'[countries_and_territories], ''[Sumdaily_confirmed_cases])",
      "IndentedOperation": "            Proxy: IterPhyOp LogOp=TableVarProxy IterCols(0, 1)('covid_19_geographic_distribution_worldwide'[countries_and_territories], ''[Sumdaily_confirmed_cases])",
      "Level": 3,
      "RowNumber": 4
    },
    {
      "Records": null,
      "Operation": "GroupSemijoin: IterPhyOp LogOp=GroupSemiJoin IterCols(0, 1)('covid_19_geographic_distribution_worldwide'[countries_and_territories], ''[Sumdaily_confirmed_cases])",
      "IndentedOperation": "                GroupSemijoin: IterPhyOp LogOp=GroupSemiJoin IterCols(0, 1)('covid_19_geographic_distribution_worldwide'[countries_and_territories], ''[Sumdaily_confirmed_cases])",
      "Level": 4,
      "RowNumber": 5
    },
    {
      "Records": 212,
      "Operation": "Spool_Iterator<SpoolIterator>: IterPhyOp LogOp=Sum_Vertipaq IterCols(0)('covid_19_geographic_distribution_worldwide'[countries_and_territories]) #Records=212 #KeyCols=26 #ValueCols=1",
      "IndentedOperation": "                    Spool_Iterator<SpoolIterator>: IterPhyOp LogOp=Sum_Vertipaq IterCols(0)('covid_19_geographic_distribution_worldwide'[countries_and_territories]) #Records=212 #KeyCols=26 #ValueCols=1",
      "Level": 5,
      "RowNumber": 6
    },
    {
      "Records": 212,
      "Operation": "ProjectionSpool<ProjectFusion<Copy>>: SpoolPhyOp #Records=212",
      "IndentedOperation": "                        ProjectionSpool<ProjectFusion<Copy>>: SpoolPhyOp #Records=212",
      "Level": 6,
      "RowNumber": 7
    },
    {
      "Records": null,
      "Operation": "DirectQueryResult : IterPhyOp #FieldCols=1 #ValueCols=1 Fields('covid_19_geographic_distribution_worldwide'[countries_and_territories])",
      "IndentedOperation": "                            DirectQueryResult : IterPhyOp #FieldCols=1 #ValueCols=1 Fields('covid_19_geographic_distribution_worldwide'[countries_and_territories])",
      "Level": 7,
      "RowNumber": 8
    },
    {
      "Records": null,
      "Operation": "ColValue<''[Sumdaily_confirmed_cases]>: LookupPhyOp LogOp=ColValue<''[Sumdaily_confirmed_cases]>''[Sumdaily_confirmed_cases] LookupCols(1)(''[Sumdaily_confirmed_cases]) Integer",
      "IndentedOperation": "        ColValue<''[Sumdaily_confirmed_cases]>: LookupPhyOp LogOp=ColValue<''[Sumdaily_confirmed_cases]>''[Sumdaily_confirmed_cases] LookupCols(1)(''[Sumdaily_confirmed_cases]) Integer",
      "Level": 2,
      "RowNumber": 9
    },
    {
      "Records": null,
      "Operation": "ColValue<'covid_19_geographic_distribution_worldwide'[countries_and_territories]>: LookupPhyOp LogOp=ColValue<'covid_19_geographic_distribution_worldwide'[countries_and_territories]>'covid_19_geographic_distribution_worldwide'[countries_and_territories] LookupCols(0)('covid_19_geographic_distribution_worldwide'[countries_and_territories]) String",
      "IndentedOperation": "        ColValue<'covid_19_geographic_distribution_worldwide'[countries_and_territories]>: LookupPhyOp LogOp=ColValue<'covid_19_geographic_distribution_worldwide'[countries_and_territories]>'covid_19_geographic_distribution_worldwide'[countries_and_territories] LookupCols(0)('covid_19_geographic_distribution_worldwide'[countries_and_territories]) String",
      "Level": 2,
      "RowNumber": 10
    }
  ],
  "LogicalQueryPlanRows": [
    {
      "Operation": "__DS0Core: GroupSemiJoin: RelLogOp VarName=__DS0Core DependOnCols()() 0-1 RequiredCols(0, 1)('covid_19_geographic_distribution_worldwide'[countries_and_territories], ''[Sumdaily_confirmed_cases])",
      "IndentedOperation": "__DS0Core: GroupSemiJoin: RelLogOp VarName=__DS0Core DependOnCols()() 0-1 RequiredCols(0, 1)('covid_19_geographic_distribution_worldwide'[countries_and_territories], ''[Sumdaily_confirmed_cases])",
      "Level": 0,
      "RowNumber": 1
    },
    {
      "Operation": "Scan_Vertipaq: RelLogOp DependOnCols()() 0-0 RequiredCols(0)('covid_19_geographic_distribution_worldwide'[countries_and_territories])",
      "IndentedOperation": "    Scan_Vertipaq: RelLogOp DependOnCols()() 0-0 RequiredCols(0)('covid_19_geographic_distribution_worldwide'[countries_and_territories])",
      "Level": 1,
      "RowNumber": 2
    },
    {
      "Operation": "Sum_Vertipaq: ScaLogOp DependOnCols(0)('covid_19_geographic_distribution_worldwide'[countries_and_territories]) Integer DominantValue=BLANK",
      "IndentedOperation": "    Sum_Vertipaq: ScaLogOp DependOnCols(0)('covid_19_geographic_distribution_worldwide'[countries_and_territories]) Integer DominantValue=BLANK",
      "Level": 1,
      "RowNumber": 3
    },
    {
      "Operation": "Scan_Vertipaq: RelLogOp DependOnCols(0)('covid_19_geographic_distribution_worldwide'[countries_and_territories]) 1-13 RequiredCols(0, 6)('covid_19_geographic_distribution_worldwide'[countries_and_territories], 'covid_19_geographic_distribution_worldwide'[daily_confirmed_cases])",
      "IndentedOperation": "        Scan_Vertipaq: RelLogOp DependOnCols(0)('covid_19_geographic_distribution_worldwide'[countries_and_territories]) 1-13 RequiredCols(0, 6)('covid_19_geographic_distribution_worldwide'[countries_and_territories], 'covid_19_geographic_distribution_worldwide'[daily_confirmed_cases])",
      "Level": 2,
      "RowNumber": 4
    },
    {
      "Operation": "'covid_19_geographic_distribution_worldwide'[daily_confirmed_cases]: ScaLogOp DependOnCols(6)('covid_19_geographic_distribution_worldwide'[daily_confirmed_cases]) Integer DominantValue=NONE",
      "IndentedOperation": "        'covid_19_geographic_distribution_worldwide'[daily_confirmed_cases]: ScaLogOp DependOnCols(6)('covid_19_geographic_distribution_worldwide'[daily_confirmed_cases]) Integer DominantValue=NONE",
      "Level": 2,
      "RowNumber": 5
    },
    {
      "Operation": "__DS0PrimaryWindowed: TopN: RelLogOp VarName=__DS0PrimaryWindowed DependOnCols()() 0-1 RequiredCols(0, 1)('covid_19_geographic_distribution_worldwide'[countries_and_territories], ''[Sumdaily_confirmed_cases])",
      "IndentedOperation": "__DS0PrimaryWindowed: TopN: RelLogOp VarName=__DS0PrimaryWindowed DependOnCols()() 0-1 RequiredCols(0, 1)('covid_19_geographic_distribution_worldwide'[countries_and_territories], ''[Sumdaily_confirmed_cases])",
      "Level": 0,
      "RowNumber": 6
    },
    {
      "Operation": "TableVarProxy: RelLogOp DependOnCols()() 0-1 RequiredCols(0, 1)('covid_19_geographic_distribution_worldwide'[countries_and_territories], ''[Sumdaily_confirmed_cases]) RefVarName=__DS0Core",
      "IndentedOperation": "    TableVarProxy: RelLogOp DependOnCols()() 0-1 RequiredCols(0, 1)('covid_19_geographic_distribution_worldwide'[countries_and_territories], ''[Sumdaily_confirmed_cases]) RefVarName=__DS0Core",
      "Level": 1,
      "RowNumber": 7
    },
    {
      "Operation": "Constant: ScaLogOp DependOnCols()() Integer DominantValue=1001",
      "IndentedOperation": "    Constant: ScaLogOp DependOnCols()() Integer DominantValue=1001",
      "Level": 1,
      "RowNumber": 8
    },
    {
      "Operation": "''[Sumdaily_confirmed_cases]: ScaLogOp DependOnCols(1)(''[Sumdaily_confirmed_cases]) Integer DominantValue=NONE",
      "IndentedOperation": "    ''[Sumdaily_confirmed_cases]: ScaLogOp DependOnCols(1)(''[Sumdaily_confirmed_cases]) Integer DominantValue=NONE",
      "Level": 1,
      "RowNumber": 9
    },
    {
      "Operation": "'covid_19_geographic_distribution_worldwide'[countries_and_territories]: ScaLogOp DependOnCols(0)('covid_19_geographic_distribution_worldwide'[countries_and_territories]) String DominantValue=NONE",
      "IndentedOperation": "    'covid_19_geographic_distribution_worldwide'[countries_and_territories]: ScaLogOp DependOnCols(0)('covid_19_geographic_distribution_worldwide'[countries_and_territories]) String DominantValue=NONE",
      "Level": 1,
      "RowNumber": 10
    },
    {
      "Operation": "Order: RelLogOp DependOnCols()() 0-1 RequiredCols(0, 1)('covid_19_geographic_distribution_worldwide'[countries_and_territories], ''[Sumdaily_confirmed_cases])",
      "IndentedOperation": "Order: RelLogOp DependOnCols()() 0-1 RequiredCols(0, 1)('covid_19_geographic_distribution_worldwide'[countries_and_territories], ''[Sumdaily_confirmed_cases])",
      "Level": 0,
      "RowNumber": 11
    },
    {
      "Operation": "TableVarProxy: RelLogOp DependOnCols()() 0-1 RequiredCols(0, 1)('covid_19_geographic_distribution_worldwide'[countries_and_territories], ''[Sumdaily_confirmed_cases]) RefVarName=__DS0PrimaryWindowed",
      "IndentedOperation": "    TableVarProxy: RelLogOp DependOnCols()() 0-1 RequiredCols(0, 1)('covid_19_geographic_distribution_worldwide'[countries_and_territories], ''[Sumdaily_confirmed_cases]) RefVarName=__DS0PrimaryWindowed",
      "Level": 1,
      "RowNumber": 12
    },
    {
      "Operation": "''[Sumdaily_confirmed_cases]: ScaLogOp DependOnCols(1)(''[Sumdaily_confirmed_cases]) Integer DominantValue=NONE",
      "IndentedOperation": "    ''[Sumdaily_confirmed_cases]: ScaLogOp DependOnCols(1)(''[Sumdaily_confirmed_cases]) Integer DominantValue=NONE",
      "Level": 1,
      "RowNumber": 13
    },
    {
      "Operation": "'covid_19_geographic_distribution_worldwide'[countries_and_territories]: ScaLogOp DependOnCols(0)('covid_19_geographic_distribution_worldwide'[countries_and_territories]) String DominantValue=NONE",
      "IndentedOperation": "    'covid_19_geographic_distribution_worldwide'[countries_and_territories]: ScaLogOp DependOnCols(0)('covid_19_geographic_distribution_worldwide'[countries_and_territories]) String DominantValue=NONE",
      "Level": 1,
      "RowNumber": 14
    }
  ]
}