Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

Bring the same column with conditions

Hi! I'm new on Power BI, so I apologize in advance if my question is stupid, but I've been looking here at this forum, and I couldn't find a solution   I have 3 tables. One table of devices, one of...
  • Sean's avatar
    9 years ago

    1) If you want this in a New Table (not a Table Visual)

    click New Table on the Modeling Tab and type this

    Summary Table =
    SUMMARIZECOLUMNS (
        Devices[DeviceName],
        "First Owner", CALCULATE (
            FIRSTNONBLANK ( Owners[OwnerName], 1 ),
            FILTER ( Device_Owner, Device_Owner[OwnerSeq] = 1 )
        ),
        "Second Owner", CALCULATE (
            FIRSTNONBLANK ( Owners[OwnerName], 1 ),
            FILTER ( Device_Owner, Device_Owner[OwnerSeq] = 2 )
        )
    )

    2) You can also achieve this without creating a New Table by creating these 2 Measures instead

    First Owner =
    CALCULATE (
        FIRSTNONBLANK ( Owners[OwnerName], 1 ),
        FILTER ( Device_Owner, Device_Owner[OwnerSeq] = 1 )
    )

    and

    Second Owner =
    CALCULATE (
        FIRSTNONBLANK ( Owners[OwnerName], 1 ),
        FILTER ( Device_Owner, Device_Owner[OwnerSeq] = 2 )
    )

    then click the Table Visual icon in the Visualizations area

    add the DeviceName from the Devices Table and the 2 Measures

    Hope this helps! :smileyhappy: