Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

How to filter ID;s based on another column

Hi, I have a table where there is ID, previoustasks_ttaskids and employee_ttaskresourceid columns. I need to filter the table to contain only the ID's where previoustask_ttaskid = id and display the employee_ttaskresourceid. Could someone please help on this.

 

 

Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    4 years ago

    Hi,

    This calculated column formula works

    Column = LOOKUPVALUE('refResourceTask (2)'[employee_ttaskresourceid],'refResourceTask (2)'[id],'refResourceTask (2)'[previoustasks_ttaskids])

    Hope this helps.

10 Replies

  • Seanan's avatar
    Seanan
    Icon for Solution Supplier rankSolution Supplier
    4 years ago

    Hi Anonymous 

    I've created a measure to achieve this.

    Matching Id's = COUNTROWS(FILTER('Ids','Ids'[PreviousTaskId] = 'Ids'[Id]))

    Table:

     

     

     

     

    Result:

     

    Kind regards,
    Seanan
    If this post helped, please consider accepting it as the solution.

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Hi Seanan for some reason I can't get any results from the measure

       

      • Seanan's avatar
        Seanan
        Icon for Solution Supplier rankSolution Supplier
        4 years ago

        Hi Anonymous 

        It appears you've created this as a calculated column. Could you please create this as a measure and then you can use it in a table visualisation.

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Icon for Super User rankSuper User
    4 years ago

    Hi,

    This calculated column formula works

    Column = LOOKUPVALUE('refResourceTask (2)'[employee_ttaskresourceid],'refResourceTask (2)'[id],'refResourceTask (2)'[previoustasks_ttaskids])

    Hope this helps.