Forum Discussion

PowerTrouble's avatar
PowerTrouble
Frequent Visitor
5 years ago
Solved

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

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 th...
Need Help
  • v-lionel-msft's avatar
    v-lionel-msft
    5 years ago

    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.

amitchandak's avatar
amitchandak
Super User
5 years ago

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's avatar
PowerTrouble
Frequent Visitor
5 years ago

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

  • v-lionel-msft's avatar
    v-lionel-msft
    Community Support
    5 years ago

    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's avatar
      PowerTrouble
      Frequent Visitor
      5 years ago

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