measure exploding dimensins

Hi Anonymous 

After importing, 

sort "delivery" on ascending firstly, sort "street" ascending secondly,

select [Meaure C], "Transform->fill down",

then filter [measure A] <> null.

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WsjAwUNJRUgZiCDJUitWBiXq4KpgAKWMTYxNTE1MgyxQkClVgiKLNCEk0KEQBpNjE1NTEzBRkgBlEWywA", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type text) meta [Serialized.Text = true]) in type table [delivery = _t, street = _t, #"measure A" = _t, #"measure B" = _t, #"measure C" = _t]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"delivery", Int64.Type}, {"street", type text}, {"measure A", Int64.Type}, {"measure B", Int64.Type}, {"measure C", Int64.Type}}),
    #"Sorted Rows" = Table.Sort(#"Changed Type",{{"delivery", Order.Ascending}, {"street", Order.Ascending}}),
    #"Filled Down" = Table.FillDown(#"Sorted Rows",{"measure C"}),
    #"Filtered Rows" = Table.SelectRows(#"Filled Down", each ([measure A] <> null))
in
    #"Filtered Rows"

Regarding performance issue, please check the ways to improve performance.

Performance Tip for Power BI; Enable Load Sucks Memory Up

Performance tip for List.Generate (1): Buffer your tables in Power BI and Power Query