test

By DAX Prism sample

Generated 2026-06-21 11:53 UTC

Summary

18 measures 3 max DAX chain depth 4 unused measure(s)

Tables & sources 6
  • fact_table · 23 step(s)

    Plain-English steps

    1. Load files from folder: FolderLocation
2. Remove columns: Extension, Date accessed, Date modified, Date created, Attributes, Folder Path, Name
3. Filter rows where [Attributes]?[Hidden]? <> true
4. Add calculated column: "Transform File"
5. Keep only columns: Transform File
6. Expand nested table column: "Transform File"
7. Set column types: Nomenclature (type), ReporterISO3 (type), ProductCode (Int64.Type), ReporterName (type), PartnerISO3 (type), PartnerName (type), Year (Int64.Type), TradeFlowName (type), TradeFlowCode (Int64.Type), TradeValue in 1000 USD (type)
8. Remove columns: Nomenclature, ReporterISO3, ReporterName, PartnerISO3, TradeFlowCode
9. Pivot column "TradeFlowName" with values from "TradeValue in 1000 USD"
10. Replace null with 0 in column "Export"
11. Replace null with 0 in column "Import"
12. Transform column "Export": _ * 1000
13. Transform column "Import": _ * 1000
14. Add calculated column: "Custom"
15. Set column types: Custom (type)
16. Remove columns: Year
17. Rename columns: Custom -> Date
18. Add calculated column: "TradeBalance"
19. Replace "Egypt, Arab Rep." with "Egypt" in column "PartnerName"
20. Replace "Ethiopia(excludes Eritrea)" with "Ethiopia" in column "PartnerName"
21. Replace "Korea, Rep." with "South Korea" in column "PartnerName"
22. Replace "Other Asia, nes" with "Taiwan" in column "PartnerName"
23. Replace "Slovak Republic" with "Slovakia" in column "PartnerName"

    Original M query

    let
    Source = Folder.Files(FolderLocation),
    #"Removed Columns" = Table.RemoveColumns(Source,{"Extension", "Date accessed", "Date modified", "Date created", "Attributes", "Folder Path", "Name"}),
    #"Filtered Hidden Files1" = Table.SelectRows(#"Removed Columns", each [Attributes]?[Hidden]? <> true),
    #"Invoke Custom Function1" = Table.AddColumn(#"Filtered Hidden Files1", "Transform File", each #"Transform File"([Content])),
    #"Removed Other Columns1" = Table.SelectColumns(#"Invoke Custom Function1", {"Transform File"}),
    #"Expanded Table Column1" = Table.ExpandTableColumn(#"Removed Other Columns1", "Transform File", Table.ColumnNames(#"Transform File"(#"Sample File"))),
    #"Changed Type" = Table.TransformColumnTypes(#"Expanded Table Column1",{{"Nomenclature", type text}, {"ReporterISO3", type text}, {"ProductCode", Int64.Type}, {"ReporterName", type text}, {"PartnerISO3", type text}, {"PartnerName", type text}, {"Year", Int64.Type}, {"TradeFlowName", type text}, {"TradeFlowCode", Int64.Type}, {"TradeValue in 1000 USD", type number}}),
    #"Removed Columns1" = Table.RemoveColumns(#"Changed Type",{"Nomenclature", "ReporterISO3", "ReporterName", "PartnerISO3", "TradeFlowCode"}),
    #"Pivoted Column" = Table.Pivot(#"Removed Columns1", List.Distinct(#"Removed Columns1"[TradeFlowName]), "TradeFlowName", "TradeValue in 1000 USD", List.Sum),
    #"Replaced Value" = Table.ReplaceValue(#"Pivoted Column",null,0,Replacer.ReplaceValue,{"Export"}),
    #"Replaced Value1" = Table.ReplaceValue(#"Replaced Value",null,0,Replacer.ReplaceValue,{"Import"}),
    #"Multiplied Column" = Table.TransformColumns(#"Replaced Value1", {{"Export", each _ * 1000, type number}}),
    #"Multiplied Column1" = Table.TransformColumns(#"Multiplied Column", {{"Import", each _ * 1000, type number}}),
    #"Added Custom" = Table.AddColumn(#"Multiplied Column1", "Custom", each Date.FromText("1/1/" & Text.From([Year]))),
    #"Changed Type1" = Table.TransformColumnTypes(#"Added Custom",{{"Custom", type date}}),
    #"Removed Columns2" = Table.RemoveColumns(#"Changed Type1",{"Year"}),
    #"Renamed Columns" = Table.RenameColumns(#"Removed Columns2",{{"Custom", "Date"}}),
    #"Added Custom1" = Table.AddColumn(#"Renamed Columns", "TradeBalance", each [Export]-[Import]),
    #"Replaced Value2" = Table.ReplaceValue(#"Added Custom1","Egypt, Arab Rep.","Egypt",Replacer.ReplaceText,{"PartnerName"}),
    #"Replaced Value3" = Table.ReplaceValue(#"Replaced Value2","Ethiopia(excludes Eritrea)","Ethiopia",Replacer.ReplaceText,{"PartnerName"}),
    #"Replaced Value4" = Table.ReplaceValue(#"Replaced Value3","Korea, Rep.","South Korea",Replacer.ReplaceText,{"PartnerName"}),
    #"Replaced Value5" = Table.ReplaceValue(#"Replaced Value4","Other Asia, nes","Taiwan",Replacer.ReplaceText,{"PartnerName"}),
    #"Replaced Value6" = Table.ReplaceValue(#"Replaced Value5","Slovak Republic","Slovakia",Replacer.ReplaceText,{"PartnerName"})
in
    #"Replaced Value6"
  • dimSIC · 25 step(s)

    Plain-English steps

    1. Load Excel workbook: C:\Users\davidk\Desktop\writing\substack\trade\data\dimSIC.xlsx
2. Navigate to sheet/table: "Sheet1"
3. Promote first row to column headers
4. Set column types: NomenclatureCode (type), Tier (Int64.Type), ProductCode (type), ProductDescription (type), Column5 (type)
5. Remove columns: NomenclatureCode, Column5
6. Filter rows where ([Tier] = 3 or [Tier] = 4
7. Add calculated column: "3digit"
8. Add calculated column: "2digit"
9. Add calculated column: "1digit"
10. Merge/join tables (left outer)
11. Expand column "dim": ProductDescription, dim.ProductDescription
12. Rename columns: ProductDescription -> Product, dim.ProductDescription -> Segment
13. Remove columns: Tier, 3digit
14. Reorder columns
15. Merge/join tables (left outer)
16. Expand column "dim": ProductDescription, dim.ProductDescription
17. Rename columns: dim.ProductDescription -> Family
18. Reorder columns
19. Remove columns: 2digit
20. Merge/join tables (left outer)
21. Expand column "dim": ProductDescription, dim.ProductDescription
22. Remove columns: 1digit
23. Rename columns: Family -> Group, dim.ProductDescription -> Family
24. Reorder columns
25. Rename columns: Family -> Category

    Original M query

    let
    Source = Excel.Workbook(File.Contents("C:\Users\davidk\Desktop\writing\substack\trade\data\dimSIC.xlsx"), null, true),
    Sheet1_Sheet = Source{[Item="Sheet1",Kind="Sheet"]}[Data],
    #"Promoted Headers" = Table.PromoteHeaders(Sheet1_Sheet, [PromoteAllScalars=true]),
    #"Changed Type" = Table.TransformColumnTypes(#"Promoted Headers",{{"NomenclatureCode", type text}, {"Tier", Int64.Type}, {"ProductCode", type text}, {"ProductDescription", type text}, {"Column5", type any}}),
    #"Removed Columns" = Table.RemoveColumns(#"Changed Type",{"NomenclatureCode", "Column5"}),
    #"Filtered Rows" = Table.SelectRows(#"Removed Columns", each ([Tier] = 3 or [Tier] = 4)),
    #"Added Custom" = Table.AddColumn(#"Filtered Rows", "3digit", each Text.Start([ProductCode], 3)),
    #"Added Custom1" = Table.AddColumn(#"Added Custom", "2digit", each Text.Start([ProductCode], 2)),
    #"Added Custom2" = Table.AddColumn(#"Added Custom1", "1digit", each Text.Start([ProductCode], 1)),
    #"Merged Queries" = Table.NestedJoin(#"Added Custom2", {"3digit"}, #"DNU-SIC", {"ProductCode"}, "dim", JoinKind.LeftOuter),
    #"Expanded dim" = Table.ExpandTableColumn(#"Merged Queries", "dim", {"ProductDescription"}, {"dim.ProductDescription"}),
    #"Renamed Columns" = Table.RenameColumns(#"Expanded dim",{{"ProductDescription", "Product"}, {"dim.ProductDescription", "Segment"}}),
    #"Removed Columns1" = Table.RemoveColumns(#"Renamed Columns",{"Tier", "3digit"}),
    #"Reordered Columns" = Table.ReorderColumns(#"Removed Columns1",{"Product", "Segment", "2digit", "1digit"}),
    #"Merged Queries1" = Table.NestedJoin(#"Reordered Columns", {"2digit"}, #"DNU-SIC", {"ProductCode"}, "dim", JoinKind.LeftOuter),
    #"Expanded dim1" = Table.ExpandTableColumn(#"Merged Queries1", "dim", {"ProductDescription"}, {"dim.ProductDescription"}),
    #"Renamed Columns1" = Table.RenameColumns(#"Expanded dim1",{{"dim.ProductDescription", "Family"}}),
    #"Reordered Columns1" = Table.ReorderColumns(#"Renamed Columns1",{"Product", "Segment", "Family", "2digit", "1digit"}),
    #"Removed Columns2" = Table.RemoveColumns(#"Reordered Columns1",{"2digit"}),
    #"Merged Queries2" = Table.NestedJoin(#"Removed Columns2", {"1digit"}, #"DNU-SIC", {"ProductCode"}, "dim", JoinKind.LeftOuter),
    #"Expanded dim2" = Table.ExpandTableColumn(#"Merged Queries2", "dim", {"ProductDescription"}, {"dim.ProductDescription"}),
    #"Removed Columns3" = Table.RemoveColumns(#"Expanded dim2",{"1digit"}),
    #"Renamed Columns2" = Table.RenameColumns(#"Removed Columns3",{{"Family", "Group"}, {"dim.ProductDescription", "Family"}}),
    #"Reordered Columns2" = Table.ReorderColumns(#"Renamed Columns2",{"ProductCode", "Family", "Group", "Segment", "Product"}),
    #"Renamed Columns3" = Table.RenameColumns(#"Reordered Columns2",{{"Family", "Category"}})
in
    #"Renamed Columns3"
  • DNU-SIC · 5 step(s)

    Plain-English steps

    1. Load Excel workbook: C:\Users\davidk\Desktop\writing\substack\trade\data\dimSIC.xlsx
2. Navigate to sheet/table: "Sheet1"
3. Promote first row to column headers
4. Set column types: NomenclatureCode (type), Tier (Int64.Type), ProductCode (type), ProductDescription (type), Column5 (type)
5. Remove columns: NomenclatureCode, Column5

    Original M query

    let
    Source = Excel.Workbook(File.Contents("C:\Users\davidk\Desktop\writing\substack\trade\data\dimSIC.xlsx"), null, true),
    Sheet1_Sheet = Source{[Item="Sheet1",Kind="Sheet"]}[Data],
    #"Promoted Headers" = Table.PromoteHeaders(Sheet1_Sheet, [PromoteAllScalars=true]),
    #"Changed Type" = Table.TransformColumnTypes(#"Promoted Headers",{{"NomenclatureCode", type text}, {"Tier", Int64.Type}, {"ProductCode", type text}, {"ProductDescription", type text}, {"Column5", type any}}),
    #"Removed Columns" = Table.RemoveColumns(#"Changed Type",{"NomenclatureCode", "Column5"})
in
    #"Removed Columns"
  • dimGeo · 6 step(s)

    Plain-English steps

    1. Load CSV file: C:\Users\davidk\Desktop\writing\substack\trade\data\dimGeo.csv
2. Set column types: Column1 (type), Column2 (type), Column3 (type), Column4 (type)
3. Promote first row to column headers
4. Set column types: country (type), continent (type), sub_region (type), Trading Block (type)
5. Filter rows where ([continent] <> ""
6. Replace "" with "ROW" in column "Trading Block"

    Original M query

    let
    Source = Csv.Document(File.Contents("C:\Users\davidk\Desktop\writing\substack\trade\data\dimGeo.csv"),[Delimiter=",", Columns=4, Encoding=1252, QuoteStyle=QuoteStyle.None]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Column1", type text}, {"Column2", type text}, {"Column3", type text}, {"Column4", type text}}),
    #"Promoted Headers" = Table.PromoteHeaders(#"Changed Type", [PromoteAllScalars=true]),
    #"Changed Type1" = Table.TransformColumnTypes(#"Promoted Headers",{{"country", type text}, {"continent", type text}, {"sub_region", type text}, {"Trading Block", type text}}),
    #"Filtered Rows" = Table.SelectRows(#"Changed Type1", each ([continent] <> "")),
    #"Replaced Value" = Table.ReplaceValue(#"Filtered Rows","","ROW",Replacer.ReplaceValue,{"Trading Block"})
in
    #"Replaced Value"
  • date_table · 1 step(s)

    Plain-English steps

    Generate a date calendar table

    Original M query

    ADDCOLUMNS(
    CALENDAR(MIN(fact_table[Date]), MAX(fact_table[Date])),
    "Year", YEAR([Date]),
    "MonthNum", MONTH([Date]),
    "Month", FORMAT([Date],"mmm"),
    "Month-Year", FORMAT([Date], "mmm yyyy"),
    "Sort Key", YEAR([Date])*100 + MONTH([Date])
)
  • MeasureTable · 2 step(s)

    Plain-English steps

    1. Create table from inline data
2. Set column types: Selection (type)

    Original M query

    let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45W8swtyC8qKVaK1YlWcq1AsEOKElNSFZwScxLzklOVYmMB", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Selection = _t]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Selection", type text}})
in
    #"Changed Type"

Relationships 3
FromToCardinalityCross-filter
fact_table.ProductCodedimSIC.ProductCodeMany-to-OneSingle
fact_table.PartnerNamedimGeo.countryMany-to-OneSingle
fact_table.Datedate_table.DateMany-to-OneSingle

Measures 18
TableNameExpression
MeasureTable DynamicMeasure 
VAR MySelection = SELECTEDVALUE(MeasureTable[Selection])
VAR ReturnValue = SWITCH(
    TRUE(),
    MySelection = "Imports", SUM(fact_table[Import])
    ,MySelection = "Exports", SUM(fact_table[Export])
    ,MySelection = "Trade Balance", SUM(fact_table[TradeBalance])
)
RETURN ReturnValue
MeasureTable Growth (Year) 
VAR DynMeasureCurrentYear = TOTALYTD(
    [DynamicMeasure], date_table[Date]
)
VAR DynMeasurePrevYear = TOTALYTD(
    [DynamicMeasure], DATEADD(date_table[Date], -1, YEAR)
)
VAR ReturnValue = DIVIDE((DynMeasureCurrentYear-DynMeasurePrevYear), DynMeasurePrevYear)

Return ReturnValue
MeasureTable SpaceCraft Segment Recent Year 
CALCULATE(
    [DynamicMeasure],
    dimSIC[Segment] = "Spacecraft",
   date_table[Year] = MAX(date_table[Year])
)
MeasureTable Aircraft Segment Recent Year 
CALCULATE(
    [DynamicMeasure],
    SEARCH("Aircraft", dimSIC[Segment], 1, 0) > 0,
    date_table[Year] = MAX(date_table[Year])
)
MeasureTable TitleSpacecraftVisual 
"SpaceCraft " & MIN(MeasureTable[Selection]) & " By Year Through " & MAX(date_table[Year])
MeasureTable TitleExports 
"Exports: " & MAX(date_table[Year])
MeasureTable RecentImports 
CALCULATE(
    SUM(fact_table[Import]), 
    YEAR(date_table[Date]) = YEAR(MAX(date_table[Date]))
)
MeasureTable RecentExports 
CALCULATE(
    SUM(fact_table[Export]), 
    YEAR(date_table[Date]) = YEAR(MAX(date_table[Date]))
)
MeasureTable RecentTradeBalance 
CALCULATE(
    SUM(fact_table[TradeBalance]), 
    YEAR(date_table[Date]) = YEAR(MAX(date_table[Date]))
)
MeasureTable TitleImports 
"Imports: " & Max(date_table[Year])
MeasureTable TitleTradeBalance 
"Trade Balance: " & Max(date_table[Year])
MeasureTable TitleGrowth 
"1 Year Growth"
MeasureTable TitleDynamicMeasure 
MIN(MeasureTable[Selection])
MeasureTable TitleDynamicMeasureGrowth 
MIN(MeasureTable[Selection]) & " Growth"
MeasureTable Growth (3 Year) 
VAR DynMeasureCurrentYear = TOTALYTD(
    [DynamicMeasure], date_table[Date]
)
VAR DynMeasurePrevYear = TOTALYTD(
    [DynamicMeasure], DATEADD(date_table[Date], -3, YEAR)
)
VAR ReturnValue = DIVIDE((DynMeasureCurrentYear-DynMeasurePrevYear), DynMeasurePrevYear)/3

Return ReturnValue
MeasureTable Title3Growth 
"3 Year Growth"
MeasureTable TitleDynamicMeasureWaterfallCategory 
MIN(MeasureTable[Selection]) & " by Category"
MeasureTable TitleDynamicMeasureWaterfall 
MIN(MeasureTable[Selection]) & " By Trading Bloc"

Columns 25
TableColumnTypeExpression
fact_table ProductCode regular
fact_table PartnerName regular
fact_table Export regular
fact_table Import regular
fact_table Date regular
fact_table TradeBalance regular
dimSIC ProductCode regular
dimSIC Category regular
dimSIC Group regular
dimSIC Segment regular
dimSIC Product regular
DNU-SIC Tier regular
DNU-SIC ProductCode regular
DNU-SIC ProductDescription regular
dimGeo country regular
dimGeo continent regular
dimGeo sub_region regular
dimGeo Trading Block regular
date_table Date regular
date_table Year regular
date_table MonthNum regular
date_table Month regular
date_table Month-Year regular
date_table Sort Key regular
MeasureTable Selection regular

Pages 6
#Page
0Landing Page
1Import/Export/TradeBalance & Growth
2Import/Export/TradeBalance & Growth by Category
3Waterfall by Trading Bloc
4Waterfall By Category
5Decomp Tree

Visuals 75
PageVisual typeField
Import/Export/TradeBalance & GrowthcardMeasureTable.RecentExports
Import/Export/TradeBalance & GrowthcardMeasureTable.YearImport
Import/Export/TradeBalance & GrowthcardMeasureTable.RecentTradeBalance
Import/Export/TradeBalance & GrowthcardMeasureTable.Growth (Year)
Import/Export/TradeBalance & GrowthslicerdimGeo.Trading Block
Import/Export/TradeBalance & Growthslicerdate_table.Year
Import/Export/TradeBalance & GrowthlineChartdate_table.Year
Import/Export/TradeBalance & GrowthlineChartdimGeo.Trading Block
Import/Export/TradeBalance & GrowthlineChartMeasureTable.Growth (Year)
Import/Export/TradeBalance & GrowthlineChartdate_table.Year
Import/Export/TradeBalance & GrowthlineChartdimGeo.Trading Block
Import/Export/TradeBalance & GrowthlineChartMeasureTable.DynamicMeasure
Import/Export/TradeBalance & GrowthpivotTableMeasureTable.Growth (Year)
Import/Export/TradeBalance & GrowthpivotTabledimGeo.Trading Block
Import/Export/TradeBalance & GrowthpivotTabledimGeo.country
Import/Export/TradeBalance & GrowthslicerdimSIC.Category
Import/Export/TradeBalance & GrowthslicerdimSIC.Group
Import/Export/TradeBalance & GrowthslicerdimSIC.Segment
Import/Export/TradeBalance & GrowthslicerdimSIC.Product
Import/Export/TradeBalance & GrowthslicerMeasureTable.Selection
Import/Export/TradeBalance & GrowthcardMeasureTable.Growth (3 Year)
Import/Export/TradeBalance & Growth by CategoryslicerMeasureTable.Selection
Import/Export/TradeBalance & Growth by CategoryslicerdimGeo.Trading Block
Import/Export/TradeBalance & Growth by Categoryslicerdate_table.Year
Import/Export/TradeBalance & Growth by CategorypivotTableMeasureTable.Growth (Year)
Import/Export/TradeBalance & Growth by CategorypivotTabledimSIC.Category
Import/Export/TradeBalance & Growth by CategorypivotTabledimSIC.Group
Import/Export/TradeBalance & Growth by CategorypivotTabledimSIC.Segment
Import/Export/TradeBalance & Growth by CategorypivotTabledimSIC.Product
Import/Export/TradeBalance & Growth by CategoryslicerdimSIC.Category
Import/Export/TradeBalance & Growth by CategoryslicerdimSIC.Group
Import/Export/TradeBalance & Growth by CategoryslicerdimSIC.Segment
Import/Export/TradeBalance & Growth by CategoryslicerdimSIC.Product
Import/Export/TradeBalance & Growth by CategorylineChartdate_table.Year
Import/Export/TradeBalance & Growth by CategorylineChartdimGeo.Trading Block
Import/Export/TradeBalance & Growth by CategorylineChartMeasureTable.DynamicMeasure
Import/Export/TradeBalance & Growth by CategorylineChartdate_table.Year
Import/Export/TradeBalance & Growth by CategorylineChartdimGeo.Trading Block
Import/Export/TradeBalance & Growth by CategorylineChartMeasureTable.Growth (Year)
Import/Export/TradeBalance & Growth by CategorycardMeasureTable.YearImport
Import/Export/TradeBalance & Growth by CategorycardMeasureTable.RecentExports
Import/Export/TradeBalance & Growth by CategorycardMeasureTable.RecentTradeBalance
Import/Export/TradeBalance & Growth by CategorycardMeasureTable.Growth (Year)
Import/Export/TradeBalance & Growth by CategorycardMeasureTable.Growth (3 Year)
Waterfall by Trading BlocslicerMeasureTable.Selection
Waterfall by Trading BlocslicerdimGeo.Trading Block
Waterfall by Trading BlocslicerdimSIC.Category
Waterfall by Trading BlocslicerdimSIC.Group
Waterfall by Trading BlocslicerdimSIC.Segment
Waterfall by Trading BlocslicerdimSIC.Product
Waterfall by Trading BlocwaterfallChartMeasureTable.DynamicMeasure
Waterfall by Trading BlocwaterfallChartdimGeo.Trading Block
Waterfall by Trading BlocwaterfallChartdate_table.Date.Variation.Date Hierarchy.Year
Waterfall by Trading BlocwaterfallChartdate_table.Date.Variation.Date Hierarchy.Quarter
Waterfall by Trading BlocwaterfallChartdate_table.Date.Variation.Date Hierarchy.Month
Waterfall by Trading BlocwaterfallChartdate_table.Date.Variation.Date Hierarchy.Day
Waterfall By CategoryslicerMeasureTable.Selection
Waterfall By CategoryslicerdimSIC.Category
Waterfall By CategoryslicerdimGeo.Trading Block
Waterfall By CategoryslicerdimGeo.country
Waterfall By CategorywaterfallChartMeasureTable.DynamicMeasure
Waterfall By CategorywaterfallChartdate_table.Date.Variation.Date Hierarchy.Year
Waterfall By CategorywaterfallChartdate_table.Date.Variation.Date Hierarchy.Quarter
Waterfall By CategorywaterfallChartdate_table.Date.Variation.Date Hierarchy.Month
Waterfall By CategorywaterfallChartdate_table.Date.Variation.Date Hierarchy.Day
Waterfall By CategorywaterfallChartdimSIC.Category
Decomp TreeslicerMeasureTable.Selection
Decomp TreeslicerdimGeo.Trading Block
Decomp TreedecompositionTreeVisualMeasureTable.DynamicMeasure
Decomp TreedecompositionTreeVisualdimGeo.Trading Block
Decomp TreedecompositionTreeVisualdimSIC.Category
Decomp TreedecompositionTreeVisualdimSIC.Group
Decomp TreedecompositionTreeVisualdimSIC.Segment
Decomp TreedecompositionTreeVisualdimSIC.Product
Decomp TreedecompositionTreeVisualdimGeo.country

Conditional formatting & dynamic titles 16
PageVisualField
Import/Export/TradeBalance & GrowthcardMeasureTable.TitleExports
Import/Export/TradeBalance & GrowthcardMeasureTable.TitleImports
Import/Export/TradeBalance & GrowthcardMeasureTable.TitleTradeBalance
Import/Export/TradeBalance & GrowthcardMeasureTable.TitleGrowth
Import/Export/TradeBalance & GrowthlineChartMeasureTable.TitleDynamicMeasureGrowth
Import/Export/TradeBalance & GrowthlineChartMeasureTable.TitleDynamicMeasure
Import/Export/TradeBalance & GrowthcardMeasureTable.Title3Growth
Import/Export/TradeBalance & Growth by CategorylineChartMeasureTable.TitleDynamicMeasure
Import/Export/TradeBalance & Growth by CategorylineChartMeasureTable.TitleDynamicMeasureGrowth
Import/Export/TradeBalance & Growth by CategorycardMeasureTable.TitleImports
Import/Export/TradeBalance & Growth by CategorycardMeasureTable.TitleExports
Import/Export/TradeBalance & Growth by CategorycardMeasureTable.TitleTradeBalance
Import/Export/TradeBalance & Growth by CategorycardMeasureTable.TitleGrowth
Import/Export/TradeBalance & Growth by CategorycardMeasureTable.Title3Growth
Waterfall by Trading BlocwaterfallChartMeasureTable.TitleDynamicMeasureWaterfall
Waterfall By CategorywaterfallChartMeasureTable.TitleDynamicMeasureWaterfallCategory

Power Query parameters 5
NameExpression
Parameter1
... meta [IsParameterQuery=true, BinaryIdentifier=#"Sample File", Type="Binary", IsParameterQueryRequired=true]
Transform Sample File
let
    Source = Excel.Workbook(Parameter1, null, true),
    Sheet1_Sheet = Source{[Item="Sheet1",Kind="Sheet"]}[Data],
    #"Promoted Headers" = Table.PromoteHeaders(Sheet1_Sheet, [PromoteAllScalars=true])
in
    #"Promoted Headers"
Sample File
let
    Source = Folder.Files("C:\Users\davidk\Desktop\writing\substack\trade\data\fact_table"),
    #"Removed Columns" = Table.RemoveColumns(Source,{"Extension", "Date accessed", "Date modified", "Date created", "Attributes", "Folder Path", "Name"}),
    Navigation1 = #"Removed Columns"{0}[Content]
in
    Navigation1
Transform File
let
    Source = (Parameter1 as binary) => let
    Source = Excel.Workbook(Parameter1, null, true),
    Sheet1_Sheet = Source{[Item="Sheet1",Kind="Sheet"]}[Data],
    #"Promoted Headers" = Table.PromoteHeaders(Sheet1_Sheet, [PromoteAllScalars=true])
in
    #"Promoted Headers"
in
    Source
FolderLocation
null meta [IsParameterQuery=true, Type="Text", IsParameterQueryRequired=true]

Unused measures 4

No other measure, calculated column, visual, filter, or dynamic title references these. They’re candidates for deletion — but verify first: DAX inside RLS filters, field parameters, and calculation groups isn’t parsed, so this list can have false positives.

TableMeasureChain depth
MeasureTable Aircraft Segment Recent Year 2
MeasureTable RecentImports 1
MeasureTable SpaceCraft Segment Recent Year 2
MeasureTable TitleSpacecraftVisual 1

Dependency explorer 84

Pick a measure or column on the left; the right pane shows what it depends on, what depends on it (DAX), and where it’s used in the report.

P Decomp Tree · page
  • V slicer #1 d1
    • C MeasureTable[Selection] d2
  • V slicer #2 d1
    • C dimGeo[Trading Block] d2
  • V decompositionTreeVisual #3 d1
    • M DynamicMeasure d2
      • C MeasureTable[Selection] d3
      • C fact_table[Import] d3
      • C fact_table[Export] d3
      • C fact_table[TradeBalance] d3
    • C dimGeo[Trading Block] d2
    • C dimSIC[Category] d2
    • C dimSIC[Group] d2
    • C dimSIC[Segment] d2
    • C dimSIC[Product] d2
    • C dimGeo[country] d2

No other measure or calculated column references this.

Not referenced by any visual, filter, or formatting rule.

P Import/Export/TradeBalance & Growth · page
  • V card #1 d1
    • M RecentExports d2
      • C fact_table[Export] d3
      • C date_table[Date] d3
    • M TitleExports d2
      • C date_table[Year] d3
  • V card #2 d1
    • M TitleImports d2
      • C date_table[Year] d3
  • V card #3 d1
    • M RecentTradeBalance d2
      • C fact_table[TradeBalance] d3
      • C date_table[Date] d3
    • M TitleTradeBalance d2
      • C date_table[Year] d3
  • V card #4 d1
    • M Growth (Year) d2
      • C date_table[Date] d3
      • M DynamicMeasure d3
        • C MeasureTable[Selection] d4
        • C fact_table[Import] d4
        • C fact_table[Export] d4
        • C fact_table[TradeBalance] d4
    • M TitleGrowth d2
  • V slicer #5 d1
    • C dimGeo[Trading Block] d2
  • V slicer #6 d1
    • C date_table[Year] d2
  • V lineChart #7 d1
    • C date_table[Year] d2
    • C dimGeo[Trading Block] d2
    • M Growth (Year) d2
      • C date_table[Date] d3
      • M DynamicMeasure d3
        • C MeasureTable[Selection] d4
        • C fact_table[Import] d4
        • C fact_table[Export] d4
        • C fact_table[TradeBalance] d4
    • M TitleDynamicMeasureGrowth d2
      • C MeasureTable[Selection] d3
  • V lineChart #8 d1
    • C date_table[Year] d2
    • C dimGeo[Trading Block] d2
    • M DynamicMeasure d2
      • C MeasureTable[Selection] d3
      • C fact_table[Import] d3
      • C fact_table[Export] d3
      • C fact_table[TradeBalance] d3
    • M TitleDynamicMeasure d2
      • C MeasureTable[Selection] d3
  • V pivotTable #9 d1
    • M Growth (Year) d2
      • C date_table[Date] d3
      • M DynamicMeasure d3
        • C MeasureTable[Selection] d4
        • C fact_table[Import] d4
        • C fact_table[Export] d4
        • C fact_table[TradeBalance] d4
    • C dimGeo[Trading Block] d2
    • C dimGeo[country] d2
  • V slicer #10 d1
    • C dimSIC[Category] d2
    • C dimSIC[Group] d2
    • C dimSIC[Segment] d2
    • C dimSIC[Product] d2
  • V slicer #12 d1
    • C MeasureTable[Selection] d2
  • V card #14 d1
    • M Growth (3 Year) d2
      • C date_table[Date] d3
      • M DynamicMeasure d3
        • C MeasureTable[Selection] d4
        • C fact_table[Import] d4
        • C fact_table[Export] d4
        • C fact_table[TradeBalance] d4
    • M Title3Growth d2

No other measure or calculated column references this.

Not referenced by any visual, filter, or formatting rule.

P Import/Export/TradeBalance & Growth by Category · page
  • V slicer #1 d1
    • C MeasureTable[Selection] d2
  • V slicer #2 d1
    • C dimGeo[Trading Block] d2
  • V slicer #3 d1
    • C date_table[Year] d2
  • V pivotTable #4 d1
    • M Growth (Year) d2
      • C date_table[Date] d3
      • M DynamicMeasure d3
        • C MeasureTable[Selection] d4
        • C fact_table[Import] d4
        • C fact_table[Export] d4
        • C fact_table[TradeBalance] d4
    • C dimSIC[Category] d2
    • C dimSIC[Group] d2
    • C dimSIC[Segment] d2
    • C dimSIC[Product] d2
  • V slicer #5 d1
    • C dimSIC[Category] d2
    • C dimSIC[Group] d2
    • C dimSIC[Segment] d2
    • C dimSIC[Product] d2
  • V lineChart #8 d1
    • C date_table[Year] d2
    • C dimGeo[Trading Block] d2
    • M DynamicMeasure d2
      • C MeasureTable[Selection] d3
      • C fact_table[Import] d3
      • C fact_table[Export] d3
      • C fact_table[TradeBalance] d3
    • M TitleDynamicMeasure d2
      • C MeasureTable[Selection] d3
  • V lineChart #9 d1
    • C date_table[Year] d2
    • C dimGeo[Trading Block] d2
    • M Growth (Year) d2
      • C date_table[Date] d3
      • M DynamicMeasure d3
        • C MeasureTable[Selection] d4
        • C fact_table[Import] d4
        • C fact_table[Export] d4
        • C fact_table[TradeBalance] d4
    • M TitleDynamicMeasureGrowth d2
      • C MeasureTable[Selection] d3
  • V card #10 d1
    • M TitleImports d2
      • C date_table[Year] d3
  • V card #11 d1
    • M RecentExports d2
      • C fact_table[Export] d3
      • C date_table[Date] d3
    • M TitleExports d2
      • C date_table[Year] d3
  • V card #12 d1
    • M RecentTradeBalance d2
      • C fact_table[TradeBalance] d3
      • C date_table[Date] d3
    • M TitleTradeBalance d2
      • C date_table[Year] d3
  • V card #13 d1
    • M Growth (Year) d2
      • C date_table[Date] d3
      • M DynamicMeasure d3
        • C MeasureTable[Selection] d4
        • C fact_table[Import] d4
        • C fact_table[Export] d4
        • C fact_table[TradeBalance] d4
    • M TitleGrowth d2
  • V card #14 d1
    • M Growth (3 Year) d2
      • C date_table[Date] d3
      • M DynamicMeasure d3
        • C MeasureTable[Selection] d4
        • C fact_table[Import] d4
        • C fact_table[Export] d4
        • C fact_table[TradeBalance] d4
    • M Title3Growth d2

No other measure or calculated column references this.

Not referenced by any visual, filter, or formatting rule.

P Landing Page · page

Has no DAX dependencies.

No other measure or calculated column references this.

Not referenced by any visual, filter, or formatting rule.

P Waterfall By Category · page
  • V slicer #1 d1
    • C MeasureTable[Selection] d2
  • V slicer #2 d1
    • C dimSIC[Category] d2
  • V slicer #3 d1
    • C dimGeo[Trading Block] d2
    • C dimGeo[country] d2
  • V waterfallChart #4 d1
    • M DynamicMeasure d2
      • C MeasureTable[Selection] d3
      • C fact_table[Import] d3
      • C fact_table[Export] d3
      • C fact_table[TradeBalance] d3
    • C dimSIC[Category] d2
    • M TitleDynamicMeasureWaterfallCategory d2
      • C MeasureTable[Selection] d3

No other measure or calculated column references this.

Not referenced by any visual, filter, or formatting rule.

P Waterfall by Trading Bloc · page
  • V slicer #1 d1
    • C MeasureTable[Selection] d2
  • V slicer #2 d1
    • C dimGeo[Trading Block] d2
  • V slicer #3 d1
    • C dimSIC[Category] d2
    • C dimSIC[Group] d2
    • C dimSIC[Segment] d2
    • C dimSIC[Product] d2
  • V waterfallChart #4 d1
    • M DynamicMeasure d2
      • C MeasureTable[Selection] d3
      • C fact_table[Import] d3
      • C fact_table[Export] d3
      • C fact_table[TradeBalance] d3
    • C dimGeo[Trading Block] d2
    • M TitleDynamicMeasureWaterfall d2
      • C MeasureTable[Selection] d3

No other measure or calculated column references this.

Not referenced by any visual, filter, or formatting rule.

V decompositionTreeVisual #3 · visual in Decomp Tree
  • M DynamicMeasure d1
    • C MeasureTable[Selection] d2
    • C fact_table[Import] d2
    • C fact_table[Export] d2
    • C fact_table[TradeBalance] d2
  • C dimGeo[Trading Block] d1
  • C dimSIC[Category] d1
  • C dimSIC[Group] d1
  • C dimSIC[Segment] d1
  • C dimSIC[Product] d1
  • C dimGeo[country] d1
  • P Decomp Tree d1

Not referenced by any visual, filter, or formatting rule.

V slicer #1 · visual in Decomp Tree
  • C MeasureTable[Selection] d1
  • P Decomp Tree d1

Not referenced by any visual, filter, or formatting rule.

V slicer #2 · visual in Decomp Tree
  • C dimGeo[Trading Block] d1
  • P Decomp Tree d1

Not referenced by any visual, filter, or formatting rule.

V card #1 · visual in Import/Export/TradeBalance & Growth
  • M RecentExports d1
    • C fact_table[Export] d2
    • C date_table[Date] d2
  • M TitleExports d1
    • C date_table[Year] d2
  • P Import/Export/TradeBalance & Growth d1

Not referenced by any visual, filter, or formatting rule.

V card #14 · visual in Import/Export/TradeBalance & Growth
  • M Growth (3 Year) d1
    • C date_table[Date] d2
    • M DynamicMeasure d2
      • C MeasureTable[Selection] d3
      • C fact_table[Import] d3
      • C fact_table[Export] d3
      • C fact_table[TradeBalance] d3
  • M Title3Growth d1
  • P Import/Export/TradeBalance & Growth d1

Not referenced by any visual, filter, or formatting rule.

V card #2 · visual in Import/Export/TradeBalance & Growth
  • M TitleImports d1
    • C date_table[Year] d2
  • P Import/Export/TradeBalance & Growth d1

Not referenced by any visual, filter, or formatting rule.

V card #3 · visual in Import/Export/TradeBalance & Growth
  • M RecentTradeBalance d1
    • C fact_table[TradeBalance] d2
    • C date_table[Date] d2
  • M TitleTradeBalance d1
    • C date_table[Year] d2
  • P Import/Export/TradeBalance & Growth d1

Not referenced by any visual, filter, or formatting rule.

V card #4 · visual in Import/Export/TradeBalance & Growth
  • M Growth (Year) d1
    • C date_table[Date] d2
    • M DynamicMeasure d2
      • C MeasureTable[Selection] d3
      • C fact_table[Import] d3
      • C fact_table[Export] d3
      • C fact_table[TradeBalance] d3
  • M TitleGrowth d1
  • P Import/Export/TradeBalance & Growth d1

Not referenced by any visual, filter, or formatting rule.

V lineChart #7 · visual in Import/Export/TradeBalance & Growth
  • C date_table[Year] d1
  • C dimGeo[Trading Block] d1
  • M Growth (Year) d1
    • C date_table[Date] d2
    • M DynamicMeasure d2
      • C MeasureTable[Selection] d3
      • C fact_table[Import] d3
      • C fact_table[Export] d3
      • C fact_table[TradeBalance] d3
  • M TitleDynamicMeasureGrowth d1
    • C MeasureTable[Selection] d2
  • P Import/Export/TradeBalance & Growth d1

Not referenced by any visual, filter, or formatting rule.

V lineChart #8 · visual in Import/Export/TradeBalance & Growth
  • C date_table[Year] d1
  • C dimGeo[Trading Block] d1
  • M DynamicMeasure d1
    • C MeasureTable[Selection] d2
    • C fact_table[Import] d2
    • C fact_table[Export] d2
    • C fact_table[TradeBalance] d2
  • M TitleDynamicMeasure d1
    • C MeasureTable[Selection] d2
  • P Import/Export/TradeBalance & Growth d1

Not referenced by any visual, filter, or formatting rule.

V pivotTable #9 · visual in Import/Export/TradeBalance & Growth
  • M Growth (Year) d1
    • C date_table[Date] d2
    • M DynamicMeasure d2
      • C MeasureTable[Selection] d3
      • C fact_table[Import] d3
      • C fact_table[Export] d3
      • C fact_table[TradeBalance] d3
  • C dimGeo[Trading Block] d1
  • C dimGeo[country] d1
  • P Import/Export/TradeBalance & Growth d1

Not referenced by any visual, filter, or formatting rule.

V slicer #10 · visual in Import/Export/TradeBalance & Growth
  • C dimSIC[Category] d1
  • C dimSIC[Group] d1
  • C dimSIC[Segment] d1
  • C dimSIC[Product] d1
  • P Import/Export/TradeBalance & Growth d1

Not referenced by any visual, filter, or formatting rule.

V slicer #12 · visual in Import/Export/TradeBalance & Growth
  • C MeasureTable[Selection] d1
  • P Import/Export/TradeBalance & Growth d1

Not referenced by any visual, filter, or formatting rule.

V slicer #5 · visual in Import/Export/TradeBalance & Growth
  • C dimGeo[Trading Block] d1
  • P Import/Export/TradeBalance & Growth d1

Not referenced by any visual, filter, or formatting rule.

V slicer #6 · visual in Import/Export/TradeBalance & Growth
  • C date_table[Year] d1
  • P Import/Export/TradeBalance & Growth d1

Not referenced by any visual, filter, or formatting rule.

V card #10 · visual in Import/Export/TradeBalance & Growth by Category
  • M TitleImports d1
    • C date_table[Year] d2
  • P Import/Export/TradeBalance & Growth by Category d1

Not referenced by any visual, filter, or formatting rule.

V card #11 · visual in Import/Export/TradeBalance & Growth by Category
  • M RecentExports d1
    • C fact_table[Export] d2
    • C date_table[Date] d2
  • M TitleExports d1
    • C date_table[Year] d2
  • P Import/Export/TradeBalance & Growth by Category d1

Not referenced by any visual, filter, or formatting rule.

V card #12 · visual in Import/Export/TradeBalance & Growth by Category
  • M RecentTradeBalance d1
    • C fact_table[TradeBalance] d2
    • C date_table[Date] d2
  • M TitleTradeBalance d1
    • C date_table[Year] d2
  • P Import/Export/TradeBalance & Growth by Category d1

Not referenced by any visual, filter, or formatting rule.

V card #13 · visual in Import/Export/TradeBalance & Growth by Category
  • M Growth (Year) d1
    • C date_table[Date] d2
    • M DynamicMeasure d2
      • C MeasureTable[Selection] d3
      • C fact_table[Import] d3
      • C fact_table[Export] d3
      • C fact_table[TradeBalance] d3
  • M TitleGrowth d1
  • P Import/Export/TradeBalance & Growth by Category d1

Not referenced by any visual, filter, or formatting rule.

V card #14 · visual in Import/Export/TradeBalance & Growth by Category
  • M Growth (3 Year) d1
    • C date_table[Date] d2
    • M DynamicMeasure d2
      • C MeasureTable[Selection] d3
      • C fact_table[Import] d3
      • C fact_table[Export] d3
      • C fact_table[TradeBalance] d3
  • M Title3Growth d1
  • P Import/Export/TradeBalance & Growth by Category d1

Not referenced by any visual, filter, or formatting rule.

V lineChart #8 · visual in Import/Export/TradeBalance & Growth by Category
  • C date_table[Year] d1
  • C dimGeo[Trading Block] d1
  • M DynamicMeasure d1
    • C MeasureTable[Selection] d2
    • C fact_table[Import] d2
    • C fact_table[Export] d2
    • C fact_table[TradeBalance] d2
  • M TitleDynamicMeasure d1
    • C MeasureTable[Selection] d2
  • P Import/Export/TradeBalance & Growth by Category d1

Not referenced by any visual, filter, or formatting rule.

V lineChart #9 · visual in Import/Export/TradeBalance & Growth by Category
  • C date_table[Year] d1
  • C dimGeo[Trading Block] d1
  • M Growth (Year) d1
    • C date_table[Date] d2
    • M DynamicMeasure d2
      • C MeasureTable[Selection] d3
      • C fact_table[Import] d3
      • C fact_table[Export] d3
      • C fact_table[TradeBalance] d3
  • M TitleDynamicMeasureGrowth d1
    • C MeasureTable[Selection] d2
  • P Import/Export/TradeBalance & Growth by Category d1

Not referenced by any visual, filter, or formatting rule.

V pivotTable #4 · visual in Import/Export/TradeBalance & Growth by Category
  • M Growth (Year) d1
    • C date_table[Date] d2
    • M DynamicMeasure d2
      • C MeasureTable[Selection] d3
      • C fact_table[Import] d3
      • C fact_table[Export] d3
      • C fact_table[TradeBalance] d3
  • C dimSIC[Category] d1
  • C dimSIC[Group] d1
  • C dimSIC[Segment] d1
  • C dimSIC[Product] d1
  • P Import/Export/TradeBalance & Growth by Category d1

Not referenced by any visual, filter, or formatting rule.

V slicer #1 · visual in Import/Export/TradeBalance & Growth by Category
  • C MeasureTable[Selection] d1
  • P Import/Export/TradeBalance & Growth by Category d1

Not referenced by any visual, filter, or formatting rule.

V slicer #2 · visual in Import/Export/TradeBalance & Growth by Category
  • C dimGeo[Trading Block] d1
  • P Import/Export/TradeBalance & Growth by Category d1

Not referenced by any visual, filter, or formatting rule.

V slicer #3 · visual in Import/Export/TradeBalance & Growth by Category
  • C date_table[Year] d1
  • P Import/Export/TradeBalance & Growth by Category d1

Not referenced by any visual, filter, or formatting rule.

V slicer #5 · visual in Import/Export/TradeBalance & Growth by Category
  • C dimSIC[Category] d1
  • C dimSIC[Group] d1
  • C dimSIC[Segment] d1
  • C dimSIC[Product] d1
  • P Import/Export/TradeBalance & Growth by Category d1

Not referenced by any visual, filter, or formatting rule.

V slicer #1 · visual in Waterfall By Category
  • C MeasureTable[Selection] d1
  • P Waterfall By Category d1

Not referenced by any visual, filter, or formatting rule.

V slicer #2 · visual in Waterfall By Category
  • C dimSIC[Category] d1
  • P Waterfall By Category d1

Not referenced by any visual, filter, or formatting rule.

V slicer #3 · visual in Waterfall By Category
  • C dimGeo[Trading Block] d1
  • C dimGeo[country] d1
  • P Waterfall By Category d1

Not referenced by any visual, filter, or formatting rule.

V waterfallChart #4 · visual in Waterfall By Category
  • M DynamicMeasure d1
    • C MeasureTable[Selection] d2
    • C fact_table[Import] d2
    • C fact_table[Export] d2
    • C fact_table[TradeBalance] d2
  • C dimSIC[Category] d1
  • M TitleDynamicMeasureWaterfallCategory d1
    • C MeasureTable[Selection] d2
  • P Waterfall By Category d1

Not referenced by any visual, filter, or formatting rule.

V slicer #1 · visual in Waterfall by Trading Bloc
  • C MeasureTable[Selection] d1
  • P Waterfall by Trading Bloc d1

Not referenced by any visual, filter, or formatting rule.

V slicer #2 · visual in Waterfall by Trading Bloc
  • C dimGeo[Trading Block] d1
  • P Waterfall by Trading Bloc d1

Not referenced by any visual, filter, or formatting rule.

V slicer #3 · visual in Waterfall by Trading Bloc
  • C dimSIC[Category] d1
  • C dimSIC[Group] d1
  • C dimSIC[Segment] d1
  • C dimSIC[Product] d1
  • P Waterfall by Trading Bloc d1

Not referenced by any visual, filter, or formatting rule.

V waterfallChart #4 · visual in Waterfall by Trading Bloc
  • M DynamicMeasure d1
    • C MeasureTable[Selection] d2
    • C fact_table[Import] d2
    • C fact_table[Export] d2
    • C fact_table[TradeBalance] d2
  • C dimGeo[Trading Block] d1
  • M TitleDynamicMeasureWaterfall d1
    • C MeasureTable[Selection] d2
  • P Waterfall by Trading Bloc d1

Not referenced by any visual, filter, or formatting rule.

M Aircraft Segment Recent Year · measure in MeasureTable
  • C dimSIC[Segment] d1
  • C date_table[Year] d1
  • M DynamicMeasure d1
    • C MeasureTable[Selection] d2
    • C fact_table[Import] d2
    • C fact_table[Export] d2
    • C fact_table[TradeBalance] d2

No other measure or calculated column references this.

Not referenced by any visual, filter, or formatting rule.

M DynamicMeasure · measure in MeasureTable
  • C MeasureTable[Selection] d1
  • C fact_table[Import] d1
  • C fact_table[Export] d1
  • C fact_table[TradeBalance] d1
  • M Growth (Year) d1
    • V card #4 d2
      • P Import/Export/TradeBalance & Growth d3
    • V lineChart #7 d2
      • P Import/Export/TradeBalance & Growth d3
    • V pivotTable #9 d2
      • P Import/Export/TradeBalance & Growth d3
    • V pivotTable #4 d2
      • P Import/Export/TradeBalance & Growth by Category d3
    • V lineChart #9 d2
      • P Import/Export/TradeBalance & Growth by Category d3
    • V card #13 d2
      • P Import/Export/TradeBalance & Growth by Category d3
  • M SpaceCraft Segment Recent Year d1
  • M Aircraft Segment Recent Year d1
  • M Growth (3 Year) d1
    • V card #14 d2
      • P Import/Export/TradeBalance & Growth d3
    • V card #14 d2
      • P Import/Export/TradeBalance & Growth by Category d3
  • V lineChart #8 d1
    • P Import/Export/TradeBalance & Growth d2
  • V lineChart #8 d1
    • P Import/Export/TradeBalance & Growth by Category d2
  • V waterfallChart #4 d1
    • P Waterfall by Trading Bloc d2
  • V waterfallChart #4 d1
    • P Waterfall By Category d2
  • V decompositionTreeVisual #3 d1
    • P Decomp Tree d2
WherePageVisual
visual Import/Export/TradeBalance & Growth lineChart
visual Import/Export/TradeBalance & Growth by Category lineChart
visual Waterfall by Trading Bloc waterfallChart
visual Waterfall By Category waterfallChart
visual Decomp Tree decompositionTreeVisual
M Growth (3 Year) · measure in MeasureTable
  • C date_table[Date] d1
  • M DynamicMeasure d1
    • C MeasureTable[Selection] d2
    • C fact_table[Import] d2
    • C fact_table[Export] d2
    • C fact_table[TradeBalance] d2
  • V card #14 d1
    • P Import/Export/TradeBalance & Growth d2
  • V card #14 d1
    • P Import/Export/TradeBalance & Growth by Category d2
WherePageVisual
visual Import/Export/TradeBalance & Growth card
visual Import/Export/TradeBalance & Growth by Category card
M Growth (Year) · measure in MeasureTable
  • C date_table[Date] d1
  • M DynamicMeasure d1
    • C MeasureTable[Selection] d2
    • C fact_table[Import] d2
    • C fact_table[Export] d2
    • C fact_table[TradeBalance] d2
  • V card #4 d1
    • P Import/Export/TradeBalance & Growth d2
  • V lineChart #7 d1
    • P Import/Export/TradeBalance & Growth d2
  • V pivotTable #9 d1
    • P Import/Export/TradeBalance & Growth d2
  • V pivotTable #4 d1
    • P Import/Export/TradeBalance & Growth by Category d2
  • V lineChart #9 d1
    • P Import/Export/TradeBalance & Growth by Category d2
  • V card #13 d1
    • P Import/Export/TradeBalance & Growth by Category d2
WherePageVisual
visual Import/Export/TradeBalance & Growth card
visual Import/Export/TradeBalance & Growth lineChart
visual Import/Export/TradeBalance & Growth pivotTable
visual Import/Export/TradeBalance & Growth by Category pivotTable
visual Import/Export/TradeBalance & Growth by Category lineChart
visual Import/Export/TradeBalance & Growth by Category card
M RecentExports · measure in MeasureTable
  • C fact_table[Export] d1
  • C date_table[Date] d1
  • V card #1 d1
    • P Import/Export/TradeBalance & Growth d2
  • V card #11 d1
    • P Import/Export/TradeBalance & Growth by Category d2
WherePageVisual
visual Import/Export/TradeBalance & Growth card
visual Import/Export/TradeBalance & Growth by Category card
M RecentImports · measure in MeasureTable
  • C fact_table[Import] d1
  • C date_table[Date] d1

No other measure or calculated column references this.

Not referenced by any visual, filter, or formatting rule.

M RecentTradeBalance · measure in MeasureTable
  • C fact_table[TradeBalance] d1
  • C date_table[Date] d1
  • V card #3 d1
    • P Import/Export/TradeBalance & Growth d2
  • V card #12 d1
    • P Import/Export/TradeBalance & Growth by Category d2
WherePageVisual
visual Import/Export/TradeBalance & Growth card
visual Import/Export/TradeBalance & Growth by Category card
M SpaceCraft Segment Recent Year · measure in MeasureTable
  • C dimSIC[Segment] d1
  • C date_table[Year] d1
  • M DynamicMeasure d1
    • C MeasureTable[Selection] d2
    • C fact_table[Import] d2
    • C fact_table[Export] d2
    • C fact_table[TradeBalance] d2

No other measure or calculated column references this.

Not referenced by any visual, filter, or formatting rule.

M Title3Growth · measure in MeasureTable

Has no DAX dependencies.

  • V card #14 d1
    • P Import/Export/TradeBalance & Growth d2
  • V card #14 d1
    • P Import/Export/TradeBalance & Growth by Category d2
WherePageVisual
formatting / dynamic title Import/Export/TradeBalance & Growth card
formatting / dynamic title Import/Export/TradeBalance & Growth by Category card
M TitleDynamicMeasure · measure in MeasureTable
  • C MeasureTable[Selection] d1
  • V lineChart #8 d1
    • P Import/Export/TradeBalance & Growth d2
  • V lineChart #8 d1
    • P Import/Export/TradeBalance & Growth by Category d2
WherePageVisual
formatting / dynamic title Import/Export/TradeBalance & Growth lineChart
formatting / dynamic title Import/Export/TradeBalance & Growth by Category lineChart
M TitleDynamicMeasureGrowth · measure in MeasureTable
  • C MeasureTable[Selection] d1
  • V lineChart #7 d1
    • P Import/Export/TradeBalance & Growth d2
  • V lineChart #9 d1
    • P Import/Export/TradeBalance & Growth by Category d2
WherePageVisual
formatting / dynamic title Import/Export/TradeBalance & Growth lineChart
formatting / dynamic title Import/Export/TradeBalance & Growth by Category lineChart
M TitleDynamicMeasureWaterfall · measure in MeasureTable
  • C MeasureTable[Selection] d1
  • V waterfallChart #4 d1
    • P Waterfall by Trading Bloc d2
WherePageVisual
formatting / dynamic title Waterfall by Trading Bloc waterfallChart
M TitleDynamicMeasureWaterfallCategory · measure in MeasureTable
  • C MeasureTable[Selection] d1
  • V waterfallChart #4 d1
    • P Waterfall By Category d2
WherePageVisual
formatting / dynamic title Waterfall By Category waterfallChart
M TitleExports · measure in MeasureTable
  • C date_table[Year] d1
  • V card #1 d1
    • P Import/Export/TradeBalance & Growth d2
  • V card #11 d1
    • P Import/Export/TradeBalance & Growth by Category d2
WherePageVisual
formatting / dynamic title Import/Export/TradeBalance & Growth card
formatting / dynamic title Import/Export/TradeBalance & Growth by Category card
M TitleGrowth · measure in MeasureTable

Has no DAX dependencies.

  • V card #4 d1
    • P Import/Export/TradeBalance & Growth d2
  • V card #13 d1
    • P Import/Export/TradeBalance & Growth by Category d2
WherePageVisual
formatting / dynamic title Import/Export/TradeBalance & Growth card
formatting / dynamic title Import/Export/TradeBalance & Growth by Category card
M TitleImports · measure in MeasureTable
  • C date_table[Year] d1
  • V card #2 d1
    • P Import/Export/TradeBalance & Growth d2
  • V card #10 d1
    • P Import/Export/TradeBalance & Growth by Category d2
WherePageVisual
formatting / dynamic title Import/Export/TradeBalance & Growth card
formatting / dynamic title Import/Export/TradeBalance & Growth by Category card
M TitleSpacecraftVisual · measure in MeasureTable
  • C MeasureTable[Selection] d1
  • C date_table[Year] d1

No other measure or calculated column references this.

Not referenced by any visual, filter, or formatting rule.

M TitleTradeBalance · measure in MeasureTable
  • C date_table[Year] d1
  • V card #3 d1
    • P Import/Export/TradeBalance & Growth d2
  • V card #12 d1
    • P Import/Export/TradeBalance & Growth by Category d2
WherePageVisual
formatting / dynamic title Import/Export/TradeBalance & Growth card
formatting / dynamic title Import/Export/TradeBalance & Growth by Category card
C date_table[Date] · column in date_table

Has no DAX dependencies.

  • M Growth (Year) d1
    • V card #4 d2
      • P Import/Export/TradeBalance & Growth d3
    • V lineChart #7 d2
      • P Import/Export/TradeBalance & Growth d3
    • V pivotTable #9 d2
      • P Import/Export/TradeBalance & Growth d3
    • V pivotTable #4 d2
      • P Import/Export/TradeBalance & Growth by Category d3
    • V lineChart #9 d2
      • P Import/Export/TradeBalance & Growth by Category d3
    • V card #13 d2
      • P Import/Export/TradeBalance & Growth by Category d3
  • M RecentImports d1
  • M RecentExports d1
    • V card #1 d2
      • P Import/Export/TradeBalance & Growth d3
    • V card #11 d2
      • P Import/Export/TradeBalance & Growth by Category d3
  • M RecentTradeBalance d1
    • V card #3 d2
      • P Import/Export/TradeBalance & Growth d3
    • V card #12 d2
      • P Import/Export/TradeBalance & Growth by Category d3
  • M Growth (3 Year) d1
    • V card #14 d2
      • P Import/Export/TradeBalance & Growth d3
    • V card #14 d2
      • P Import/Export/TradeBalance & Growth by Category d3

Not referenced by any visual, filter, or formatting rule.

C date_table[Month-Year] · column in date_table

Has no DAX dependencies.

No other measure or calculated column references this.

Not referenced by any visual, filter, or formatting rule.

C date_table[Month] · column in date_table

Has no DAX dependencies.

No other measure or calculated column references this.

Not referenced by any visual, filter, or formatting rule.

C date_table[MonthNum] · column in date_table

Has no DAX dependencies.

No other measure or calculated column references this.

Not referenced by any visual, filter, or formatting rule.

C date_table[Sort Key] · column in date_table

Has no DAX dependencies.

No other measure or calculated column references this.

Not referenced by any visual, filter, or formatting rule.

C date_table[Year] · column in date_table

Has no DAX dependencies.

  • M SpaceCraft Segment Recent Year d1
  • M Aircraft Segment Recent Year d1
  • M TitleSpacecraftVisual d1
  • M TitleExports d1
    • V card #1 d2
      • P Import/Export/TradeBalance & Growth d3
    • V card #11 d2
      • P Import/Export/TradeBalance & Growth by Category d3
  • M TitleImports d1
    • V card #2 d2
      • P Import/Export/TradeBalance & Growth d3
    • V card #10 d2
      • P Import/Export/TradeBalance & Growth by Category d3
  • M TitleTradeBalance d1
    • V card #3 d2
      • P Import/Export/TradeBalance & Growth d3
    • V card #12 d2
      • P Import/Export/TradeBalance & Growth by Category d3
  • V slicer #6 d1
    • P Import/Export/TradeBalance & Growth d2
  • V lineChart #7 d1
    • P Import/Export/TradeBalance & Growth d2
  • V lineChart #8 d1
    • P Import/Export/TradeBalance & Growth d2
  • V slicer #3 d1
    • P Import/Export/TradeBalance & Growth by Category d2
  • V lineChart #8 d1
    • P Import/Export/TradeBalance & Growth by Category d2
  • V lineChart #9 d1
    • P Import/Export/TradeBalance & Growth by Category d2
WherePageVisual
visual Import/Export/TradeBalance & Growth slicer
visual Import/Export/TradeBalance & Growth lineChart
visual Import/Export/TradeBalance & Growth lineChart
visual Import/Export/TradeBalance & Growth by Category slicer
visual Import/Export/TradeBalance & Growth by Category lineChart
visual Import/Export/TradeBalance & Growth by Category lineChart
C dimGeo[continent] · column in dimGeo

Has no DAX dependencies.

No other measure or calculated column references this.

Not referenced by any visual, filter, or formatting rule.

C dimGeo[country] · column in dimGeo

Has no DAX dependencies.

  • V pivotTable #9 d1
    • P Import/Export/TradeBalance & Growth d2
  • V slicer #3 d1
    • P Waterfall By Category d2
  • V decompositionTreeVisual #3 d1
    • P Decomp Tree d2
WherePageVisual
visual Import/Export/TradeBalance & Growth pivotTable
visual Waterfall By Category slicer
visual Decomp Tree decompositionTreeVisual
C dimGeo[sub_region] · column in dimGeo

Has no DAX dependencies.

No other measure or calculated column references this.

Not referenced by any visual, filter, or formatting rule.

C dimGeo[Trading Block] · column in dimGeo

Has no DAX dependencies.

  • V slicer #5 d1
    • P Import/Export/TradeBalance & Growth d2
  • V lineChart #7 d1
    • P Import/Export/TradeBalance & Growth d2
  • V lineChart #8 d1
    • P Import/Export/TradeBalance & Growth d2
  • V pivotTable #9 d1
    • P Import/Export/TradeBalance & Growth d2
  • V slicer #2 d1
    • P Import/Export/TradeBalance & Growth by Category d2
  • V lineChart #8 d1
    • P Import/Export/TradeBalance & Growth by Category d2
  • V lineChart #9 d1
    • P Import/Export/TradeBalance & Growth by Category d2
  • V slicer #2 d1
    • P Waterfall by Trading Bloc d2
  • V waterfallChart #4 d1
    • P Waterfall by Trading Bloc d2
  • V slicer #3 d1
    • P Waterfall By Category d2
  • V slicer #2 d1
    • P Decomp Tree d2
  • V decompositionTreeVisual #3 d1
    • P Decomp Tree d2
WherePageVisual
visual Import/Export/TradeBalance & Growth slicer
visual Import/Export/TradeBalance & Growth lineChart
visual Import/Export/TradeBalance & Growth lineChart
visual Import/Export/TradeBalance & Growth pivotTable
visual Import/Export/TradeBalance & Growth by Category slicer
visual Import/Export/TradeBalance & Growth by Category lineChart
visual Import/Export/TradeBalance & Growth by Category lineChart
visual Waterfall by Trading Bloc slicer
visual Waterfall by Trading Bloc waterfallChart
visual Waterfall By Category slicer
visual Decomp Tree slicer
visual Decomp Tree decompositionTreeVisual
C dimSIC[Category] · column in dimSIC

Has no DAX dependencies.

  • V slicer #10 d1
    • P Import/Export/TradeBalance & Growth d2
  • V pivotTable #4 d1
    • P Import/Export/TradeBalance & Growth by Category d2
  • V slicer #5 d1
    • P Import/Export/TradeBalance & Growth by Category d2
  • V slicer #3 d1
    • P Waterfall by Trading Bloc d2
  • V slicer #2 d1
    • P Waterfall By Category d2
  • V waterfallChart #4 d1
    • P Waterfall By Category d2
  • V decompositionTreeVisual #3 d1
    • P Decomp Tree d2
WherePageVisual
visual Import/Export/TradeBalance & Growth slicer
visual Import/Export/TradeBalance & Growth by Category pivotTable
visual Import/Export/TradeBalance & Growth by Category slicer
visual Waterfall by Trading Bloc slicer
visual Waterfall By Category slicer
visual Waterfall By Category waterfallChart
visual Decomp Tree decompositionTreeVisual
C dimSIC[Group] · column in dimSIC

Has no DAX dependencies.

  • V slicer #10 d1
    • P Import/Export/TradeBalance & Growth d2
  • V pivotTable #4 d1
    • P Import/Export/TradeBalance & Growth by Category d2
  • V slicer #5 d1
    • P Import/Export/TradeBalance & Growth by Category d2
  • V slicer #3 d1
    • P Waterfall by Trading Bloc d2
  • V decompositionTreeVisual #3 d1
    • P Decomp Tree d2
WherePageVisual
visual Import/Export/TradeBalance & Growth slicer
visual Import/Export/TradeBalance & Growth by Category pivotTable
visual Import/Export/TradeBalance & Growth by Category slicer
visual Waterfall by Trading Bloc slicer
visual Decomp Tree decompositionTreeVisual
C dimSIC[Product] · column in dimSIC

Has no DAX dependencies.

  • V slicer #10 d1
    • P Import/Export/TradeBalance & Growth d2
  • V pivotTable #4 d1
    • P Import/Export/TradeBalance & Growth by Category d2
  • V slicer #5 d1
    • P Import/Export/TradeBalance & Growth by Category d2
  • V slicer #3 d1
    • P Waterfall by Trading Bloc d2
  • V decompositionTreeVisual #3 d1
    • P Decomp Tree d2
WherePageVisual
visual Import/Export/TradeBalance & Growth slicer
visual Import/Export/TradeBalance & Growth by Category pivotTable
visual Import/Export/TradeBalance & Growth by Category slicer
visual Waterfall by Trading Bloc slicer
visual Decomp Tree decompositionTreeVisual
C dimSIC[ProductCode] · column in dimSIC

Has no DAX dependencies.

No other measure or calculated column references this.

Not referenced by any visual, filter, or formatting rule.

C dimSIC[Segment] · column in dimSIC

Has no DAX dependencies.

  • M SpaceCraft Segment Recent Year d1
  • M Aircraft Segment Recent Year d1
  • V slicer #10 d1
    • P Import/Export/TradeBalance & Growth d2
  • V pivotTable #4 d1
    • P Import/Export/TradeBalance & Growth by Category d2
  • V slicer #5 d1
    • P Import/Export/TradeBalance & Growth by Category d2
  • V slicer #3 d1
    • P Waterfall by Trading Bloc d2
  • V decompositionTreeVisual #3 d1
    • P Decomp Tree d2
WherePageVisual
visual Import/Export/TradeBalance & Growth slicer
visual Import/Export/TradeBalance & Growth by Category pivotTable
visual Import/Export/TradeBalance & Growth by Category slicer
visual Waterfall by Trading Bloc slicer
visual Decomp Tree decompositionTreeVisual
C DNU-SIC[ProductCode] · column in DNU-SIC

Has no DAX dependencies.

No other measure or calculated column references this.

Not referenced by any visual, filter, or formatting rule.

C DNU-SIC[ProductDescription] · column in DNU-SIC

Has no DAX dependencies.

No other measure or calculated column references this.

Not referenced by any visual, filter, or formatting rule.

C DNU-SIC[Tier] · column in DNU-SIC

Has no DAX dependencies.

No other measure or calculated column references this.

Not referenced by any visual, filter, or formatting rule.

C fact_table[Date] · column in fact_table

Has no DAX dependencies.

No other measure or calculated column references this.

Not referenced by any visual, filter, or formatting rule.

C fact_table[Export] · column in fact_table

Has no DAX dependencies.

  • M DynamicMeasure d1
    • M Growth (Year) d2
      • V card #4 d3
        • P Import/Export/TradeBalance & Growth d4
      • V lineChart #7 d3
        • P Import/Export/TradeBalance & Growth d4
      • V pivotTable #9 d3
        • P Import/Export/TradeBalance & Growth d4
      • V pivotTable #4 d3
        • P Import/Export/TradeBalance & Growth by Category d4
      • V lineChart #9 d3
        • P Import/Export/TradeBalance & Growth by Category d4
      • V card #13 d3
        • P Import/Export/TradeBalance & Growth by Category d4
    • M SpaceCraft Segment Recent Year d2
    • M Aircraft Segment Recent Year d2
    • M Growth (3 Year) d2
      • V card #14 d3
        • P Import/Export/TradeBalance & Growth d4
      • V card #14 d3
        • P Import/Export/TradeBalance & Growth by Category d4
    • V lineChart #8 d2
      • P Import/Export/TradeBalance & Growth d3
    • V lineChart #8 d2
      • P Import/Export/TradeBalance & Growth by Category d3
    • V waterfallChart #4 d2
      • P Waterfall by Trading Bloc d3
    • V waterfallChart #4 d2
      • P Waterfall By Category d3
    • V decompositionTreeVisual #3 d2
      • P Decomp Tree d3
  • M RecentExports d1
    • V card #1 d2
      • P Import/Export/TradeBalance & Growth d3
    • V card #11 d2
      • P Import/Export/TradeBalance & Growth by Category d3

Not referenced by any visual, filter, or formatting rule.

C fact_table[Import] · column in fact_table

Has no DAX dependencies.

  • M DynamicMeasure d1
    • M Growth (Year) d2
      • V card #4 d3
        • P Import/Export/TradeBalance & Growth d4
      • V lineChart #7 d3
        • P Import/Export/TradeBalance & Growth d4
      • V pivotTable #9 d3
        • P Import/Export/TradeBalance & Growth d4
      • V pivotTable #4 d3
        • P Import/Export/TradeBalance & Growth by Category d4
      • V lineChart #9 d3
        • P Import/Export/TradeBalance & Growth by Category d4
      • V card #13 d3
        • P Import/Export/TradeBalance & Growth by Category d4
    • M SpaceCraft Segment Recent Year d2
    • M Aircraft Segment Recent Year d2
    • M Growth (3 Year) d2
      • V card #14 d3
        • P Import/Export/TradeBalance & Growth d4
      • V card #14 d3
        • P Import/Export/TradeBalance & Growth by Category d4
    • V lineChart #8 d2
      • P Import/Export/TradeBalance & Growth d3
    • V lineChart #8 d2
      • P Import/Export/TradeBalance & Growth by Category d3
    • V waterfallChart #4 d2
      • P Waterfall by Trading Bloc d3
    • V waterfallChart #4 d2
      • P Waterfall By Category d3
    • V decompositionTreeVisual #3 d2
      • P Decomp Tree d3
  • M RecentImports d1

Not referenced by any visual, filter, or formatting rule.

C fact_table[PartnerName] · column in fact_table

Has no DAX dependencies.

No other measure or calculated column references this.

Not referenced by any visual, filter, or formatting rule.

C fact_table[ProductCode] · column in fact_table

Has no DAX dependencies.

No other measure or calculated column references this.

Not referenced by any visual, filter, or formatting rule.

C fact_table[TradeBalance] · column in fact_table

Has no DAX dependencies.

  • M DynamicMeasure d1
    • M Growth (Year) d2
      • V card #4 d3
        • P Import/Export/TradeBalance & Growth d4
      • V lineChart #7 d3
        • P Import/Export/TradeBalance & Growth d4
      • V pivotTable #9 d3
        • P Import/Export/TradeBalance & Growth d4
      • V pivotTable #4 d3
        • P Import/Export/TradeBalance & Growth by Category d4
      • V lineChart #9 d3
        • P Import/Export/TradeBalance & Growth by Category d4
      • V card #13 d3
        • P Import/Export/TradeBalance & Growth by Category d4
    • M SpaceCraft Segment Recent Year d2
    • M Aircraft Segment Recent Year d2
    • M Growth (3 Year) d2
      • V card #14 d3
        • P Import/Export/TradeBalance & Growth d4
      • V card #14 d3
        • P Import/Export/TradeBalance & Growth by Category d4
    • V lineChart #8 d2
      • P Import/Export/TradeBalance & Growth d3
    • V lineChart #8 d2
      • P Import/Export/TradeBalance & Growth by Category d3
    • V waterfallChart #4 d2
      • P Waterfall by Trading Bloc d3
    • V waterfallChart #4 d2
      • P Waterfall By Category d3
    • V decompositionTreeVisual #3 d2
      • P Decomp Tree d3
  • M RecentTradeBalance d1
    • V card #3 d2
      • P Import/Export/TradeBalance & Growth d3
    • V card #12 d2
      • P Import/Export/TradeBalance & Growth by Category d3

Not referenced by any visual, filter, or formatting rule.

C MeasureTable[Selection] · column in MeasureTable

Has no DAX dependencies.

  • M DynamicMeasure d1
    • M Growth (Year) d2
      • V card #4 d3
        • P Import/Export/TradeBalance & Growth d4
      • V lineChart #7 d3
        • P Import/Export/TradeBalance & Growth d4
      • V pivotTable #9 d3
        • P Import/Export/TradeBalance & Growth d4
      • V pivotTable #4 d3
        • P Import/Export/TradeBalance & Growth by Category d4
      • V lineChart #9 d3
        • P Import/Export/TradeBalance & Growth by Category d4
      • V card #13 d3
        • P Import/Export/TradeBalance & Growth by Category d4
    • M SpaceCraft Segment Recent Year d2
    • M Aircraft Segment Recent Year d2
    • M Growth (3 Year) d2
      • V card #14 d3
        • P Import/Export/TradeBalance & Growth d4
      • V card #14 d3
        • P Import/Export/TradeBalance & Growth by Category d4
    • V lineChart #8 d2
      • P Import/Export/TradeBalance & Growth d3
    • V lineChart #8 d2
      • P Import/Export/TradeBalance & Growth by Category d3
    • V waterfallChart #4 d2
      • P Waterfall by Trading Bloc d3
    • V waterfallChart #4 d2
      • P Waterfall By Category d3
    • V decompositionTreeVisual #3 d2
      • P Decomp Tree d3
  • M TitleSpacecraftVisual d1
  • M TitleDynamicMeasure d1
    • V lineChart #8 d2
      • P Import/Export/TradeBalance & Growth d3
    • V lineChart #8 d2
      • P Import/Export/TradeBalance & Growth by Category d3
  • M TitleDynamicMeasureGrowth d1
    • V lineChart #7 d2
      • P Import/Export/TradeBalance & Growth d3
    • V lineChart #9 d2
      • P Import/Export/TradeBalance & Growth by Category d3
  • M TitleDynamicMeasureWaterfallCategory d1
    • V waterfallChart #4 d2
      • P Waterfall By Category d3
  • M TitleDynamicMeasureWaterfall d1
    • V waterfallChart #4 d2
      • P Waterfall by Trading Bloc d3
  • V slicer #12 d1
    • P Import/Export/TradeBalance & Growth d2
  • V slicer #1 d1
    • P Import/Export/TradeBalance & Growth by Category d2
  • V slicer #1 d1
    • P Waterfall by Trading Bloc d2
  • V slicer #1 d1
    • P Waterfall By Category d2
  • V slicer #1 d1
    • P Decomp Tree d2
WherePageVisual
visual Import/Export/TradeBalance & Growth slicer
visual Import/Export/TradeBalance & Growth by Category slicer
visual Waterfall by Trading Bloc slicer
visual Waterfall By Category slicer
visual Decomp Tree slicer

Additional Info / Business Logic

This is a public sample report generated by DAX Prism from a demo Power BI template. Upload your own .pbit to produce one like it.