Forum Discussion
Post PatronMeasure to combine multiple columns for filtering
Hi, in my table, I have several columns that I would like to be able to combine and then filter from. These are the column names:
Barrier / Tape / Tags
Damaged Equipment
Fall Protection
Garbage / Debris
Gear / Debris on Deck
Head / Knee Banger
Hoses / Cords (Obstructing Path)
Ice Patches
Ladder / Stair Access
Lighting
Liquid on Ground / Spill
More Safe Behaviours
Nails in Wood / On Ground
Neatness
Overhead Ice
Potential Falling Object(s) Removed
Potential Pinch Points
PPE
Product on Ground
Product Storage / Labeling
Rocks on Road / Walkway
Safety Equipment
Scaffold (Adjust / Neatness)
Sharp Object / Cladding
Signage
Steam / Product Exposure
Uneven Ground / Tripping Hazard
Vehicles
Walkways Clear
Weather Related Behaviours
Is there a simple way to create a measure that will combine the results from each column?
patri0t82，
Please follow the guide in the knowledge base below to create table and measure .
https://community.powerbi.com/t5/Community-Knowledge-Base/Dynamic-column-based-on-slicer-selection/ta-p/162635
Regards,
Lydia
10 Replies
patri0t82 This would be pretty straightforward in the Query Editor with the options to combine columns. But the DAX method has been answered here.- https://community.powerbi.com/t5/Desktop/help-how-to-merge-2-columns/td-p/53920
patri0t82Hey, thanks for replying. I tool a look at merging the query, but I'm not sure it's the right approach. Under each of those headers, I don't have a count, or number - I have other text strings. I'd like to be able to filter by header and then again count the number of instances for each text string. Does that make sense?
patri0t82,
Select the columns in your table and click "Merge Column" under Tranform ribbon to merge your columns.
Additionally, I am not clear about your requirement that count number of instances for each text string, could you please share sample data of your table and post expected result?
Regards,
Lydia