Counting same values in different columns

[Anonymous]

Hello everyone! This is my first question here.

My problem is as it follows. I have my data from an excel archive and I have 4 columns that have pre defined values to assign to them. I want to count each of these values from the 4 columns and if possible, to make slicers out of them. I believe that the workaround would be to create a new table having columns for each of these predefined words and making a count for each word in their respective column, but i don't know how.

The only thing each row have in common is the column "Categoria" filled as "Producto". When "Categoría" = "Institucional" i would just fill Producto, Producto2, Producto3 and Producto4 as blank or "-". I don't know if this is useful information.

I would like to have a measure to make visuals that counts (based on example in picture): Desodorante: 4, Cabello: 2, Baby: 2, and exclude "-" and blanks (i can just leave blanks instead of "-" as well).

Thank you in advance!

[ryan_mayu · Accepted solution]

@Anonymous 

you can try in pq, select first three columns and unpivot other coluns

Unpivot columns (Power Query) (microsoft.com)

Then it will be easier for you to do the calculation