Forum Discussion
raymond
Post Patron
Post PatronCount if a value occurs in multiple columns per row
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" occur...
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" ) )
Hello,
I treied this but didn't work in power Query neither in DAX 😕