Need Help to new measure or/and column by comnbine 2 tables

[erikzzy]

Hello everyone,

I have 2 tables. I want that have the 3rd table by adding measure or column. But my measure doesn't work.

Thanks for your help.

My measure:

Measure =

var X = SELECTEDVALUE(Table2[id])

return

SELECTCOLUMNS(FILTER(Table1,Table1[id]=X),"new_column",Table1[response])

Table1.

Table 2. 

Table 3I want to have.

[AntrikshSharma]

Try this:

=
ADDCOLUMNS ( Table2, "c", RELATED ( Table1[Response] ) )

regarding the other 2 columns n & p, what is the logic? 

[erikzzy]

Thanks your reply.

For the n and p : in the table 1, every report_id represents one record. For example (report_id = aaa), there a one blue(c) secondhand(p) car Nissan (n). I want to have these 3 features in one line in table3.  If some feature is no recorded, we substitute par No Value ( blank() ) .

Thanks one more time, 

[AntrikshSharma · Accepted solution]

See if this works for you:

Table 2 =
ADDCOLUMNS (
    Table2,
    "c", RELATED ( Table1[Response] ),
    "n",
    VAR A =
        SELECTCOLUMNS (
            FILTER ( Table1, Table1[ID] = Table2[ID] ),
            "1", Table1[Report ID]
        )
    VAR B =
        SELECTCOLUMNS (
            FILTER ( Table1, Table1[Report ID] = A && Table1[Type Question] = "n" ),
            "2", Table1[Response]
        )
    RETURN
        B,
    "P",
    VAR A =
        SELECTCOLUMNS (
            FILTER ( Table1, Table1[ID] = Table2[ID] ),
            "1", Table1[Report ID]
        )
    VAR B =
        SELECTCOLUMNS (
            FILTER ( Table1, Table1[Report ID] = A && Table1[Type Question] = "p" ),
            "2", Table1[Response]
        )
    RETURN
        B
)

[erikzzy]

Thanks your reply. its works!

[AntrikshSharma]

Replace Table 2(name) at the top with Table 3 to avoid confusion.