Formula becomes slow after connecting string

[Zepox]

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.

[Anonymous]

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.