Solved: Re: Data for "Overlap matrix"

KristofferAJ · ‎01-24-2022

Hi,

I simply can't get my head around how I can build my raw data to be able to show following example in powerBI:

In essense I want to have matrix which can show overlap - but how should my raw data look?

I would appreciate any input or tips

Thanks

Kristoffer

CNENFRNL · ‎01-24-2022

Unpivot this matrix, that's all.

Thanks to the great efforts by MS engineers to simplify syntax of DAX! Most beginners are SUCCESSFULLY MISLED to think that they could easily master DAX; but it turns out that the intricacy of the most frequently used RANKX() is still way beyond their comprehension!

DAX is simple, but NOT EASY!

View solution in original post

sid_5005 · ‎02-01-2024

I also have a similar usecase.Can you please elaborate more on the solution.
Thanks.

Ashish_Mathur · ‎02-01-2024

Hi,

The proposed solution is that In the Query Editor, you right click on the Same Color? column and click on "Unpivot Other Columns".

Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

KristofferAJ · ‎01-24-2022

That was prompt! and exactly what I needed...! thanks

CNENFRNL · ‎01-24-2022

Unpivot this matrix, that's all.

Thanks to the great efforts by MS engineers to simplify syntax of DAX! Most beginners are SUCCESSFULLY MISLED to think that they could easily master DAX; but it turns out that the intricacy of the most frequently used RANKX() is still way beyond their comprehension!

DAX is simple, but NOT EASY!