How to add 2 columns into single column in matrix visual

[Bhavyasree]

Here i have added Segment column and Totalorder dax function.Now i want add "Standard Class" from the Ship Mode as a new under under Home Office.Can anyone pls help me on this.

[v-easonf-msft]

Hi, @Bhavyasree 

If I understand you correctly, you may need to drag field "Ship Mode" to the row of Matrix.

Best Regards,
Community Support Team _ Eason

[Bhavyasree]

Thanks for your reply but I dont want to add Ship Mode Column.I want to add only "Standard Class" From the ShiMode column.

[v-easonf-msft]

Hi, @Bhavyasree 

Is this what you want? If so, try to filter data in the filter pane of this table visual.

Best Regards,
Community Support Team _ Eason

[Bhavyasree]

I dont want Hierarchy also ...I want it to add it as a new row under Home Office Segment. I think i need to do groupby but im not sure about that .If it is correct please share the dax function of Groupby.

[v-easonf-msft · Accepted solution]

Hi, @Bhavyasree 

Not fully sure what you want.

Maybe you need add another table like:

Table 2 = UNION(VALUES('Table'[Segment]),{"Standard Class"})

Then count the total orders based on this new table.

NewTotalOrders =
IF (
    MAX ( 'Table 2'[Segment] ) IN VALUES ( 'Table'[Segment] ),
    CALCULATE (
        COUNT ( 'Table'[Order ID] ),
        'Table'[Segment] = MAX ( 'Table 2'[Segment] )
    ),
    CALCULATE ( COUNT ( 'Table'[Order ID] ), 'Table'[Ship Mode] = "Standard Class" )
)

Please check if attached pbix could work for you.

Best Regards,
Community Support Team _ Eason

[Bhavyasree]

This is what i want .Thank you so much.

[Bhavyasree]

I dont want Hierarchy also ...I want it to add it as a new row under Home Office Segment. I think i need to do groupby but im not sure about that .If it is correct please share the dax function of Groupby.