Forum Discussion

Zepox's avatar
Zepox
Frequent Visitor
3 years ago

Formula becomes slow after connecting string

Hello,

 

I have the following formula:

 

Order Status = 
[Columns Tested] 
//& " / "
& [Order quantity]

 

Which works fine, but when I uncomment the & " / " part it becomes slow to the point where it throws an error which says there is not enough memory to complete this operation. The formula works when I place it in a table with 1 column but when I add more columns it starts giving an error. It might be worth noting that the referenced measures work no matter what when I place them in the table.

Columns tested counts the rows of a FACT table with transactions
Order quantity is a simple sum

Any idea why this happens? Suggestions would be greatly appreciated.

Need Help

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi Zepox 

    You can try to use CONCATENATE() function.

    e.g 

    Order Status = CONCATENATE([Columns Tested],"/"&[Order quantity])

    And many factors may result in the slow performance  such as complex relationship between data model. You can refer to the following link to optimize the perform of calculated column.

    Optimization guide for Power BI - Power BI | Microsoft Learn

    Speed/Performance aspects – The BIccountant

     

    Best Regards!

    Yolo Zhu

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.