count by column for each row with condition

[eliasayyy]

hello everyone,
i have different campaigns and my measure for each is 

Campaign 1 = 
IF(
    MAX(ifood_df[AcceptedCmp1]) =1,
    "Accepted",
    "Rejected"
)

so i put it in my table:

and it looks like that

now i need to create a new measure that counts number of "Accepted" in each column row
so customer 1 has rejected all campaigns so i need the count to be 0

customer 15 accepted campaign 1 and 5 so count should be 2

[Jihwan_Kim · Accepted solution]

Hi,

I am not sure how your datamodel looks like, but please check the below picture and the attached pbix file.

Count accepted: =
COUNTROWS (
    FILTER (
        UNION (
            ADDCOLUMNS ( DISTINCT ( ifood_df[Customer] ), "@campaign", [Campaign 1] ),
            ADDCOLUMNS ( DISTINCT ( ifood_df[Customer] ), "@campaign", [Campaign 2] ),
            ADDCOLUMNS ( DISTINCT ( ifood_df[Customer] ), "@campaign", [Campaign 3] ),
            ADDCOLUMNS ( DISTINCT ( ifood_df[Customer] ), "@campaign", [Campaign 4] ),
            ADDCOLUMNS ( DISTINCT ( ifood_df[Customer] ), "@campaign", [Campaign 5] )
        ),
        [@campaign] = "Accepted"
    )
) + 0