Forum Discussion

jak8282's avatar
jak8282
Icon for Helper III rankHelper III
3 years ago

Test on two column against two columns from another table

Hi,   I have an interactions table with   Manager        |   Agent fred  bloggs   |   Joe Bloggs Joanne bloggs   |   Joe Bloggs   And a current manager table with   Manager        |   Agent...
Need Help
PowerBIEnthu's avatar
PowerBIEnthu
Icon for Resolver I rankResolver I
3 years ago
CALCULATE (
    FIRSTNONBLANK ( Manager[Interactions], 1 ),
    FILTER ( ALL ( current Manager Table), Manager[Agent] = Current Manager Table[Agent] )
)


 Try something like this

  • jak8282's avatar
    jak8282
    Icon for Helper III rankHelper III
    3 years ago

    Hi PowerBIEnthu ,

     

    That is only filtering on the agent, I need it to filter on manager and agent.

     

    Thanks

     

    Chris