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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
f1254lipm
Frequent Visitor

Poor performance of calculation groups format string

Hi,

I have a problem with slow performance when using calculation group formats from tabular model in SSAS 2019. I have a pivot table with 3 measures and when I was using just the measures the performance was good.

Then I had the requirement to add the ability to change the format or units of values by selecting the format in a filter so I created a calculation group with one item per format and defined all items as SELECTEDMEASURE() and defined the required format strings into Format string expression. This is the article from sqlbi about this approach but I used much easier expressions just hardcoded formats like "0.00" https://www.sqlbi.com/articles/controlling-format-strings-in-calculation-groups/

Then I added that calculation group into a filter of the pivot table and the calculation group works as expected: when I select for example two decimals in the filter the measures are formatted as two decimals etc. but the format change takes at least a minute sometimes many minutes. This leads to the report being unusable. Are there some ways to improve the performance or different techniques for dynamic formats with the same functionality but better performance? The solution needs to be compatible with Excel.

Thank you for your time,
Filip

1 ACCEPTED SOLUTION
Anonymous
Not applicable

HI @f1254lipm,

It sounds like you faced the performance issue to process the Dax expressions.

For this scenario, I'd like to suggest you try to use t-SQL query to do apply formal operations, they should not affect getting data and refresh performance. (live connection mode seems not support to use t-SQL statement, perhaps you can try to convert it to direct query mode to enable this on data connector)

Regards,

Xiaoxin Sheng

View solution in original post

1 REPLY 1
Anonymous
Not applicable

HI @f1254lipm,

It sounds like you faced the performance issue to process the Dax expressions.

For this scenario, I'd like to suggest you try to use t-SQL query to do apply formal operations, they should not affect getting data and refresh performance. (live connection mode seems not support to use t-SQL statement, perhaps you can try to convert it to direct query mode to enable this on data connector)

Regards,

Xiaoxin Sheng

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.