Forum Discussion
shelbyallen99
4 years agoNew Member
NEED HELP - Advanced Text Filtering (Multiple Columns)
Hi there, Power BI Community! I'm working with a team of engineers. Different engineers on the team are assigned to hundreds of on-going projects. To organize these projects (names, descriptions, d...
amitchandak
4 years agoSuper User
shelbyallen99 , I would like the answer this one if that can help
I want to be able to filter for: if the Q3 Engineer equals "John Doe" OR the Q4 Engineer equals "John Doe" OR the Q4+ Engineer equals "John Doe"
if you do not need slicer
a measure =
calculate(count(Table[COlumn]), filter(Table, [ Q3 Engineer] ="John Doe" || [Q4 Engineer] = "John Doe" || [Q4+ Engineer] = "John Doe" ) )
If you need slicer. Create one independent name table with all names. DO NOT join this with table
Then try like
measure =
var _name = allselected(Name[Name])
return
calculate(count(Table[COlumn]), filter(Table, [ Q3 Engineer] in _name " || [Q4 Engineer] in _name || [Q4+ Engineer] in _name ) )