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 ...
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.

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.

      • Anonymous's avatar
        Anonymous
        Not applicable
        4 years ago

        Hi Seanan It seems that the end result  is the same when using it to measure. Might have something to do with blank spaces ðŸ¤”