Matrix Visual

I think you are describing an "asymmetric" matrix.  Please see the 2nd approach described in this article (Calculation Groups).

Building a Matrix with Asymmetrical Columns and Rows in Power BI - Excelerator BI

 

Pat

 

Hi, rveerasamy ;

You could create a new column to add a “Fleet id" row ,then create a measure as follows:

1.create a new table

new =
VAR _cate =
    SUMMARIZE ( 'Table', [ Category] )
VAR _fleet =
    SUMMARIZE ( 'Table', "Category", "Fleet id" )
RETURN
    UNION ( _cate, _fleet )

2.new measure

Measure =
VAR _count =
    CALCULATE (
        COUNT ( 'Table'[ID] ),
        ALLEXCEPT ( 'Table', 'Table'[account name] ))
VAR _sum =
    CALCULATE (
        SUM ( [sales amount ] ),
        FILTER (
            ALLEXCEPT ( 'Table', 'Table'[account name] ),
            [ Category] = MAX ( 'new'[ Category] )))
VAR _value =
    IF ( MAX ( 'new'[ Category] ) = "Fleet id", _count, _sum )
RETURN
    IF (
        HASONEVALUE ( 'new'[ Category] ),
        _value,
        CALCULATE (
            SUM ( [sales amount ] ),
            ALLEXCEPT ( 'Table', 'Table'[account name] )
        ) + _count)

The final output is shown below:

Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi, rveerasamy ;

Is the above answer helpful to you? If so, Would you mind accept the helpful replies as solutions? Then we are able to close the thread. More people who have the same requirement will find the solution quickly and benefit here. Thank you.

Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.