Creating table

[mervetitirinli]

Hello everyone,

I would like to help arrangement matrix on Power BI. Could you please help me to find solution?

I have two data sources. They can be connected with each other by "PNo". I want to create table like below. How can I do it?
The * column will be a measure of how many "PNo" numbers are found.

[amitchandak]

@mervetitirinli , Based on what I got, You have unpivot the data(P columns) in Data1 table

https://radacad.com/pivot-and-unpivot-with-power-bi