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...
Need Help
  • ryan_mayu's avatar
    ryan_mayu
    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
ryan_mayu's avatar
ryan_mayu
Icon for Super User rankSuper User
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
  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Thanks for your help. Would this be possible if Project Owners are a measure that concatenates several different project owners if they have the same project ID? I have a separate measure for that, so was wondering if I could do something like "if contains" or something of that sort. 

    • ryan_mayu's avatar
      ryan_mayu
      Icon for Super User rankSuper User
      1 year ago

      do you mean multiple seleciton or something else? could you pls update the sample data and expected output?

      • v-aatheeque's avatar
        v-aatheeque
        Icon for Community Support rankCommunity Support
        1 year ago

        Hi Anonymous 

        I wanted to follow up on your question regarding the possibility of using a measure to concatenate multiple project owners based on the same project ID.

        To assist you more effectively, could you please provide the sample data and the expected output? This will help us understand your requirements better and offer a more targeted solution.

        Thank you for your cooperation, and I look forward to your response!