Calculate Pairwise Combinations without using Calculated Tables

[cassendar987]

I have the following data model:

Class	Category	Type	Value
Class 1	1	T1	2
Class 1	2	T2	3
Class 1	3	T1	1
Class 1	4	T2	5
Class 2	5	T1	9
Class 2	6	T2	17

I want to calculate the pairwise comparison of categories with different types for each class group.
Example:

In Class 1: I will compare (1 vs 2  ,   1 vs 4  ,   3 vs 2   and   3 vs 4)

I want to display the result in a Matrix:

I know that this can be achieved using a Calculated Table, but I'm using a live streaming connection to a semantic model, and with calculated tables data doesn't get refreshed when pushed.

I've tried multipl data models, but I couldn't found any solutions that can lead to this exact result.

Can anyone help me with this?

Thanks

[v-kpoloju-msft]

Hi @cassendar987,

May i know has your issue been resolved? If the response provided by the community member @Anonymous, addressed your query, could you please confirm? It helps us ensure that the solutions provided are effective and beneficial for everyone.

If yes, kindly accept the useful reply as a solution and give us Kudos. It would be appreciated.

Thank you for your understanding!

[v-kpoloju-msft]

Hi @cassendar987,

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.

Thank you.

[v-kpoloju-msft]

Hi @cassendar987,

I hope this information is helpful. Please let me know if you have any further questions or if you'd like to discuss this further. If this answers your question, please Accept it as a solution and give it a 'Kudos' so others can find it easily.

Thank you.

[Anonymous]

Hi @cassendar987 

My idea is to create a table to list all pairwise comparisons in advance.

Then create two measures T1 and T2 to calculate the specific value for each comparison. 

I have attached the demo pbix at bottom. Hope it would be helpful. 

Best Regards,
Jing
If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!

[Akash_Varuna]

Hi @cassendar987 I think you need to Preprocess the data inorder to achive that use a script (SQL or Python) to generate all pairwise comparisons for each class.Then create a structure where each row represents one comparison with corresponding CategoryType and Value.Then set up a matrix visualisation using the new table