Forum Discussion
Filter multiple columns that have the same possible values and display only columns with x
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 ChenIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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.
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.
Hi PowerTrouble ,
Is your table like this?
Maybe you can 'Unpivot the columns'.
Best regards,
Lionel ChenIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I'm gonna look into this! Thanks for pointing it out.
I also updated the post with an example of how the table is formatted.