Forum Discussion

intrasight's avatar
intrasight
Icon for Helper IV rankHelper IV
10 years ago

Table.SelectRows() fails to filter

Using the Google Analytics connector again.

let
    Source = GoogleAnalytics.Accounts(),
    #"Account" = Source{[Id="xxx"]}[Data],
    #"Site" = #"Account"{[Id="yyy"]}[Data],
    #"View" = #"Site"{[Id="zzz"]}[Data],
    #"Added Items" = Cube.Transform(#"View", 
       {
          {Cube.AddAndExpandDimensionColumn, "ga:yearMonth", {"ga:yearMonth"}, {"Month of Year"}}, 
          {Cube.AddMeasureColumn, "Pageviews", "ga:pageviews"},
          {Cube.AddMeasureColumn, "Avg. Time on Page", "ga:avgTimeOnPage"}, 
          {Cube.AddMeasureColumn, "Entrances", "ga:entrances"}, 
          {Cube.AddMeasureColumn, "Unique Pageviews", "ga:uniquePageviews"}
       }
    ),
    #"Filtered Rows" = Table.SelectRows(#"Added Items", each [Month of Year] = "201605"),
    #"Sorted Rows" = Table.Sort(#"Filtered Rows",{{"Unique Pageviews", Order.Descending}, {"Pageviews", Order.Descending}})
in
    #"Sorted Rows"

the resulting table still has a row for every month. Power BI bug I assume?

Interestingly, if I add

          {Cube.AddAndExpandDimensionColumn, "ga:pagePath", {"ga:pagePath"}, {"Page"}}, 

Then the filtering does work. So this is a strange bug.

3 Replies

    • Vicky_Song's avatar
      Vicky_Song
      Icon for Impactful Individual rankImpactful Individual

      intrasight, could you please help to provide one .pbix file with which we can quickly reproduce your issue? 

      • arify's avatar
        arify
        Icon for Microsoft Employee rankMicrosoft Employee

        intrasight, we fixed this issue, it should be available to you in the release that will be around the end of September.

         

        Thanks for reporting this to us!