SAP BW Apply Parameter to Measure

[Anonymous]

Good afternoon!

I am trying to filter my query to only retrieve rows from SAP BW with a measure value greater than 0. For example, if the query originally pulls:

• 0units|1 red|springfield
• 2units|1 red|California

I would only want the query to retrieve:

• 2units|1 red|California

The dataset consists of over 2 million rows therefore the query must limit the data retrieved as opposed to filtering after retrieval. I have copied below the current query from Advanced Editor and bold and underlined the measure that I would want to apply the greater than 0 parameter. I would greatly appreciate support on this!

let
    Source = SapBusinessWarehouse.Cubes("Web URL", "___", "___", "__", [Implementation="2.0"]),
    SourceA = Source{[Name="SourceA"]}[Data],
    #"SourceA/SourceA_Transaction" = SourceA{[Id="SourceA/SourceA_Transaction"]}[Data],
    #"Added Items" = Cube.Transform(#"SourceA/SourceA_Transaction",
        {
            {Cube.ApplyParameter, "[YGTHH12]", {{"[0Column1].[1777]", "[0Column1].[1555]"}}},
            {Cube.AddMeasureColumn, "Measure1", "[Measures].[222222222]"},
            {Cube.AddMeasureColumn, "Measure2", "[Measures].[333333333]"},
            {Cube.AddAndExpandDimensionColumn, "[0Column1]", {"[0Column1].[LEVEL01]"}, {"Column1._____ Level 01"}},
            {Cube.AddAndExpandDimensionColumn, "[0Column2]", {"[0Column1].[LEVEL01]"}, {"Column2.___ Level 01"}}
        }),

    in
 _____

Thanks,

Tom

[fzfz]

Hello ,

I have some issue. If anyone has a good idea on how to do this , I would be more than happy 

Thank you 

[mwegener]

Hi @Anonymous ,

I think you can only filter the SAP BW query if you insert a corresponding MDX statement in the Advanced options.

https://docs.microsoft.com/en-us/power-bi/desktop-sap-bw-connector