Forum Discussion

stauffermi's avatar
stauffermi
New Member
4 years ago
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...
Need Help
  • amitchandak's avatar
    amitchandak
    4 years ago

    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]) )

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

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]) )