Reply
Highlighted
Frequent Visitor
Posts: 2
Registered: ‎11-08-2017
Accepted Solution

HELP - Combine columns into one including duplicate counts

[ Edited ]

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


Accepted Solutions
Frequent Visitor
Posts: 2
Registered: ‎11-08-2017

Re: HELP - Combine columns into one including duplicate counts


All Replies
Frequent Visitor
Posts: 2
Registered: ‎11-08-2017

Re: HELP - Combine columns into one including duplicate counts