Filter multiple columns that have the same possible values and display only columns with x

[PowerTrouble]

The title is a little messy, so I want to clarify.

I have a table, in this table are people and qualifications, a lot of qualifications that are separate columns. These qualifications all have the same possible values, but I just want to display all of the qualifications that say "Certified" and leave the rest. As I said though, there are a lot and I was wondering what the best method of doing this is, especially so it would just work if, for example, a new qualification was added.

Here's an example of what the table looks like:

[v-lionel-msft]

Hi @PowerTrouble ,

Has your problem been solved?

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[PowerTrouble]

Not yet sadly.

[amitchandak]

@PowerTrouble , Create a measure like

calculate(countrows(Table), Filter(Table, Table[qualifications] ="Certified"))

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

[PowerTrouble]

Hey, I've updated the post with an example image if that is any help.

[v-lionel-msft · Accepted solution]

Hi @PowerTrouble ,

I found that the data structure of your table is similar to what I guessed. After you "Unpivot the table", filter out the rows with [Value] = "Certified". Isn't this what you want?

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[PowerTrouble]

This looks to be correct, thanks a lot for the help.

[PowerTrouble]

Ah, sorry I was unclear. Each qualification is separate, so for example, an IT column and a Fitness Instructor column, etc. This is what's causing the headache. I didn't make the table but I've been asked to display the quals this way. 

[v-lionel-msft]

Hi @PowerTrouble ,

Is your table like this?

Maybe you can 'Unpivot the columns'.

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[PowerTrouble]

I also updated the post with an example of how the table is formatted.

[PowerTrouble]

I'm gonna look into this! Thanks for pointing it out.