Forum Discussion
Calculate Pairwise Combinations without using Calculated Tables
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 ...
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!