Es posible contar valores repetidos en toda una tabla

[Mig]

Hola, queria ver si alguien sabe como podria contar valores que se repiten en diferentes columnas de una forma sencilla. Como tengo muchas columnas es demasiado largo contar una por una , por ejemplo, todos los valores de "competente" que se repiten

[amitchandak]

@Mig , first unpivot

https://radacad.com/pivot-and-unpivot-with-power-bi
Transpose : https://yodalearning.com/tutorials/power-query-helps-transposing-data/

The

count(Table[Value]) - distinctcount(Table[Value])

will give you repeated value

[mahoneypat]

The easiest way to do this would be to unpivot all the columns and load the table.  You can then make a table visual with the values in the Value column, and add the attribute column (the former column headers) with an aggregation of count.

If this works for you, please mark it as the solution.  Kudos are appreciated too.  Please let me know if not.

Regards,

Pat