Merger or join or combine two matrix

Hi umairarshad ,

bhanu_gautam Thanks for your concern about this case!

And umairarshad , I'm guessing that the reason you have two columns of GSEs in your matrix is because you put Ageing in the Rows of the matrix, Status in the Columns of the matrix, and then you put GSEs in the Values, which by default returns a separate column of GSEs for each element in the Columns.

You can try this way:
Here is my sample data:

Use these DAXs to create measures:

S/A status = 
VAR _Count = 
CALCULATE(
    COUNT('Table'[Status]),
    'Table'[Ageing] = MAX('Table'[Ageing]) && 'Table'[Status] = "S/A"
)
VAR _Total = 
CALCULATE(
    COUNTROWS('Table'),
    ALLEXCEPT('Table', 'Table'[Ageing])
)
RETURN
_Count / _Total

U/S status = 
VAR _Count = 
CALCULATE(
    COUNT('Table'[Status]),
    'Table'[Ageing] = MAX('Table'[Ageing]) && 'Table'[Status] = "U/S"
)
VAR _Total = 
CALCULATE(
    COUNTROWS('Table'),
    ALLEXCEPT('Table', 'Table'[Ageing])
)
RETURN
_Count / _Total

Count of GSE = 
CALCULATE(
    COUNT('Table'[GSE]),
    ALLEXCEPT('Table', 'Table'[Ageing])
)

Place Ageing in the Rows of the matrix, don't put any fields in the Columns, and place the above three measures in the Values, and the final output is as below:

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