Need help with Matrix Visual where Rows and Columns both are measures

[harshalv_98]

Hello All,

We have a requirement where in a matrix visual both rows and columns are measures which can be seen in the mockup below and we have implemented it using "Calculation Groups" with which we can keep both rows and columns as measures. But when we are using Calculation Groups to implement it, the load time is high for the visual even for sample dataset.

Are there any alternative approaches to create similar matrix visual? Or is there any way to make changes to the Calculation Groups to make the processing optimal?

Thanks in advance.

[audreygerred]

Can you share your DAX for each of the measures? It is possible that some may need to be optimized. 

[harshalv_98]

Hi @audreygerred , I was just experimenting with sample dataset and so the measures are very simple like SUM(sales). But still the load time is very high. So, if you know any other way to implement the same matrix, then it would be very helpful.

Thanks.