HOW DO I ACHIEVE BELOW OUTPUT IMAGE USING DAX? MY INPUT AND OUTPUT IMAGES ARE DISPLAYED BELOW.

[swapnareddy]

[v-yanjiang-msft · Accepted solution]

Hi @swapnareddy ,

According to your description, here's my solution.

Table 2 = 
UNION (
    SUMMARIZE ( 'Table', 'Table'[Column2], 'Table'[Column3], 'Table'[Column1] ),
    ADDCOLUMNS (
        SUMMARIZE ( 'Table', [Column2], [Column3] ),
        "Column1",
            CONCATENATEX (
                FILTER (
                    ALL ( 'Table' ),
                    'Table'[Column2] = EARLIER ( 'Table'[Column2] )
                        && 'Table'[Column3] = EARLIER ( 'Table'[Column3] )
                ),
                [Column1]
            )
    )
)

Get the result.

In this way, rows are not in the same order as expected. Or you can just create a measure.

Column1' =
CONCATENATEX (
    FILTER (
        ALL ( 'Table' ),
        'Table'[Column2] = MAX ( 'Table'[Column2] )
            && 'Table'[Column3] = MAX ( 'Table'[Column3] )
    ),
    [Column1]
)

Put two visuals together.

I attach the sample below for reference.

Best Regards,
Community Support Team _ kalyj

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@swapnareddy , New table

Union( summarize(Table, [Column2],[colum1], [column1]),

summarize(Table, [Column2],[colum3], "column3", concatenatex(Table, [Column1]))

)