Matrix Visual

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.