Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

How to slice data for several columns

Project ID Project Owner Name Project Owner ID Manager Manager ID Project Details A Jeff 123 Mike 789 etc B John 234 Matt 678 etc C Jack 345 John 234 etc   Man...
  • ryan_mayu's avatar
    1 year ago

    Anonymous 

    do not create relationship between two tables.

    create a measure

    Measure = if(max('Table'[Manager])=max(Manager[Managers])||max(Manager[Managers])=max('Table'[Project Owner Name]),1)
    and add this measure to visual filter and set to 1
     
    pls see the attachment below