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

      • Anonymous's avatar
        Anonymous
        Not applicable
        4 years ago

        Hi Seanan . These ID:s actually describes employee positions. Id is the position id, previous task id's are telling that is a superior for the  particular position etc. So there is a superior-employee hierargy represented and the employee_ttaskresourceid is the person who holds the position

         

        This is a bit tricky as this hierargy is not represented in any other form. For example nowhere in the db there is no clear indicator who is a superior and who is not and I need to report employee work leaves by the superior etc.

         

        here is a sample pic from dev. environment what this data represents