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

Helpful resources

Announcements
Community Highlights

Community Highlights

Find out what's new in the Power BI Community!

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Virtual Launch Event

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 98 members 1,506 guests
Please welcome our newest community members: