Forum Discussion
Solved
filter on two columns (or condition)
Hi, i have two tables looking like this: Locations: ID Location Name 1 Location 1 2 Location 2 3 Location 3 Requests: ID name Location 1 Location 2 1 Jon...
stauffermi , do not join two tables or create one more independent table
Then try measure like
measure =
var _tab = summarize(allselected(Table1), Table1[Location ID])
return
Calculate(Count(Table2[ID]), filter(Table2, Table[Location 1] in _tab || Table[Location 2] in _tab ) )
or
measure =
var _tab = summarize(allselected(Table1), Table1[Location ID])
return
Calculate(Count(Table2[ID]), filter(Table2, Table[Location 1] in _tab || Table[Location 2] in _tab ), values(Table2[ID]) )
Thank you very much for your help! I was able to solve it with the measure.