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.

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 🤔