Count if a value occurs in multiple columns per row

[raymond]

Dear Community,

Initial Situation:

There is a table of multiple columns: btn_A to btn_D. 

Sought Output as a new column:

The function should count how often a value such as "Interest" occurs in multiple columns. See Count_Interest

How can this be achieved?

[MARSU95]

Hello, 
I treied this but didn't work in power Query neither in DAX 😕

[Zubair_Muhammad]

@raymond

Try As a caclulated column

Count_Interest =
VAR RowValues =
    UNION (
        ROW ( "MyTable", TableName[btn_A] ),
        ROW ( "MyTable", TableName[btn_B] ),
        ROW ( "MyTable", TableName[btn_C] ),
        ROW ( "MyTable", TableName[btn_D] )
    )
RETURN
    COUNTROWS ( FILTER ( RowValues, [MyTable] = "Interest" ) )

[Zubair_Muhammad · Accepted solution]

@raymond

Similarly

Count_Conversion =
VAR RowValues =
    UNION (
        ROW ( "MyTable", TableName[btn_A] ),
        ROW ( "MyTable", TableName[btn_B] ),
        ROW ( "MyTable", TableName[btn_C] ),
        ROW ( "MyTable", TableName[btn_D] )
    )
RETURN
    COUNTROWS ( FILTER ( RowValues, [MyTable] = "Conversion" ) )