how to improve performance of matrix visual

[oakgogo]

In order to built a hirearchy column and row headers in matrix, I built up row ad column dimension table, and use SWITCH in DAX to find out relevent values, it seems like this:

calculation=
SWITCH(TRUE,

col1=“AAA” && col2="adsfadsa",CALCULATE(SUM( value1),condition1,...

col1=“AAB” && col2="adsfavsadfa", CALCULATE(SUM( value2),condition1,...

.....

......

there are so many rows and columns that this dax turned out to be hunders of lines,

and it take more than 6 seconds to see the value in the metrix, it is impossible use other method, so is there any solution I can lower the time to show up the value?

[Anonymous · Accepted solution]

Hi, @oakgogo 

You can find Performance analysis on Power BI Desktop, use it to record when your matrix displays values, and see where you spend more time.

Here's how to use Performance Analysis:

Use Performance Analyzer to examine report element performance in Power BI Desktop - Power BI | Micr...

It's possible that your measure is making loading the visual's values slow. When using metrics, performance issues can arise, and you need to adjust the performance of the metrics and design an appropriate data model. You can check out the documentation on how to optimize, and here are the links:

Optimization guide for Power BI - Power BI | Microsoft Learn

Optimize a model for performance in Power BI - Training | Microsoft Learn

I apologize for not providing you with substantial assistance.

How to Get Your Question Answered Quickly 

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards

Yongkang Hua

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

[PijushRoy]

Hi @oakgogo 

Can you please share SNAP for your data structure and expected result?
If possible, please share sample data and SNAP of the expected result.