If statement with Path

[Anonymous]

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!

[Anonymous · Accepted solution]

Hi @Anonymous ,

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

Best Regards,

Jay

[Anonymous]

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

[Anonymous]

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!

[Anonymous]

In path function, However, if there are two identical employee IDs that have different manager IDs, the PATH function returns an error. A single manager need to be assign for Ali.
Check for reference:https://docs.microsoft.com/en-us/dax/path-function-dax

[Anonymous]

Anyone who can solve my issue?

Thanks in advance!