HELP - Combine columns into one including duplicate counts

Hi Guys,

HELP!! :)

any help would be apprciated :)

Below is the formula i have found on the site it has achieved half my goal just need the other half and i believe it has to do with the count value below i have also added a screen of the data i would like the total count of brands in column 1, 2 and 3 for brands

ShowRow = 
IF (
    HASONEVALUE(Brand[T]),
    IF (
        COUNTROWS ( FILTER ( 'Training App', 'Training App'[Brand Covered] = VALUES ( Brand[T] ) ) )
            || COUNTROWS ( FILTER ( 'Training App', 'Training App'[Brand Covered 2] = VALUES ( Brand[T] ) ) )
            || COUNTROWS ( FILTER ( 'Training App', 'Training App'[Brand Covered 3] = VALUES ( Brand[T] ) ) ),
        1,
        0
    )
)