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