cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
JustinWesty Frequent Visitor
Frequent Visitor

HELP - Combine columns into one including duplicate counts

Hi Guys,

HELP!! Smiley Happy

any help would be apprciated Smiley Happy

 

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

 Capture.PNG

1 ACCEPTED SOLUTION

Accepted Solutions
JustinWesty Frequent Visitor
Frequent Visitor

Re: HELP - Combine columns into one including duplicate counts

1 REPLY 1
JustinWesty Frequent Visitor
Frequent Visitor

Re: HELP - Combine columns into one including duplicate counts