Combine 3 rows in matrix as extra row and calculate values in matrix visual

[Evanooruvan]

I have this matrix visual in powerbi

Now i want to add a extra row in matrix visual combining bxx,exx,fxx ( named as BEF) 
How to calculate values like below visual in powerbi matrix,

thank you, any help is appreciated 🙂

[PaulDBrown]

Is the new rows supposed to be bynamic (you intend to select the companies in a slicer for example) or will it be a fixed number of companies (always the same)?

[Evanooruvan]

It will be fixed for those 3 companies

[PaulDBrown · Accepted solution]

The easiest way is to create a new group with the companies as follows. First the model

In the company table, create a new group as follows:

Now create the matrix with the fields from the date and company tables and the measures to get:

Another alternative is to create the company table using:

Company with groups =
VAR _BEF =
    CALCULATETABLE (
        VALUES ( fTable[Company] ),
        FILTER (
            fTable,
            CONTAINSSTRING ( fTable[Company], "B" )
                || CONTAINSSTRING ( fTable[Company], "E" )
                || CONTAINSSTRING ( fTable[Company], "F" )
        )
    )
VAR _ROWS =
    DISTINCTCOUNT ( fTable[Company] )
RETURN
    ADDCOLUMNS (
        DISTINCT ( fTable[Company] ),
        "BEF",
            IF (
                fTable[Company] IN _BEF,
                CONCATENATEX ( _BEF, fTable[Company], " & " ),
                fTable[Company]
            ),
        "Order",
            IF (
                fTable[Company] IN _BEF,
                _ROWS + 1,
                RANKX ( ALL ( fTable[Company] ), fTable[Company],, ASC )
            )
    )

and then set up the matrix as follows

If you want to create the visual exactly as you posted it can be done (let us know).

Sample PBIX file attached

[Evanooruvan]

thank you so much 🙂