Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

If statement with Path

Hi Guys,

 

I have a simple problem with Path function. The situation is I have an Employees table which contains the following data:

 

ACTIVE  NAME MANAGER
True      Ali               Ara

False     Ali               Roger

 

So I need to use Path function with IF statement that only returns Path function when ACTIVE is True. For this situation I used this formule:
IF('Employees'ACTIVE = "Ture", Path('Employees'[NAME],'Employees'[MANAGER]),BLANK())

But unfortunately I got this error:
Each value in 'Employees'[NAME] must have the same value in 'Employees'[MANAGER]. The value 'Ali' has multiple values.


Thanks in advance!

General Comment
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi Anonymous ,

     

    I didn't get an error when using the sample data you have provided.

     

    Best Regards,

    Jay

5 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi Anonymous ,

     

    I didn't get an error when using the sample data you have provided.

     

    Best Regards,

    Jay

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      I really dont understand why it does now works. I used the same formule as your hahah. But thanks it works now!

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Anyone who can solve my issue?

       

      Thanks in advance!

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi mohityash,

     

    I understand but If I filter on Active True then it will be identical. That is why I need to use IF statement to filter Active True. But it seems like that the PATH function does not listen to the IF statement.

    So is there any solution for this issue?

    Thanks you!