HELP - Combine columns into one including duplicate counts

[JustinWesty]

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
    )
)

 

[JustinWesty · Accepted solution]

Solved in the below link

after a change of searching

http://community.powerbi.com/t5/Desktop/Distinct-values-and-count-values-from-multiple-columns/td-p/...