Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
jhsimb
Frequent Visitor

Cube.CollapseAndRemoveColumns slow after List.Buffer

Using List.Buffer for filtering in a column improved performance, but applying collapse (column) caused a significant slowdown in the query. Any help to this problem? Thanks in advance.

 

2 REPLIES 2
v-jingzhan-msft
Community Support
Community Support

Hi @jhsimb 

How do you apply collapse (column)? Can you provide the M code you used?

 

Best Regards,
Jing

Hi, here is the code:

 

#"Vendedor BAANV" = Cube.Transform(#"Filtro Supervisor",
{
{Cube.AddAndExpandDimensionColumn, "[Piramide Ventas]", {"[Piramide Ventas].[Piramide Ventas].[Vendedor BAANV]"}, {"Vendedor BAANV"}}
}),
Cliente = Cube.Transform(#"Vendedor BAANV",
{
{Cube.AddAndExpandDimensionColumn, "[Cliente]", {"[Cliente].[Por Cliente].[Cliente]"}, {"Cliente"}}
}),
Medidas = Cube.Transform(Cliente,
{
{Cube.AddMeasureColumn, "No. Clientes Efectivos", "[Measures].[No. Clientes Efectivos]"},
{Cube.AddMeasureColumn, "No. Clientes Ruta", "[Measures].[No. Clientes Ruta]"}
}),
ListQuery = List.Buffer(Lista),
#"Filas filtradas" = Table.SelectRows(Medidas, each (List.Contains(ListQuery,[Cliente])<>true )),
#"Columnas contraídas y quitadas" = Cube.CollapseAndRemoveColumns(#"Filas filtradas", {"Cliente"})
in
#"Columnas contraídas y quitadas"

 

Thanks

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.