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 

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 ðŸ¤”

 

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

    Hi Anonymous 

    Would you be able to send the PBIX without any sensitive data so I can take a look?

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

        Hi Anonymous 

        I've found the issue as to why the measure is returning 0 rows. In the dataset non of the previousId's are matching the Id column. For example, the measure will check row 10 of the previousId column and see if row 10 in the Id column is a match. This means that it is not looking for row 10 of previousId across the entire Id column. 

         

        Is the expected result to look for a previousid across the entire Id column?