PATH - DAX Measure - A table of multiple values was supplied where a single value was expected

[Sebski]

Hi,

I am a stuck trying to create a new measure using PATH.

I have the following data, one column has the CostCenterID, the next the CostCenterID of the Parent.

I want to create a new measure that will display the path of the CostCenter like this:

Name Parent Path

501		501
501-01	501	501|501-01
501-01-01	501-01	501|501-01|501-01-01
501-01-01-01	501-01-01	501|501-01|501-01-01|501-01-01-01
501-01-01-02	501-01-01	501|501-01|501-01-01|501-01-01-02
501-01-01-03	501-01-01	501|501-01|501-01-01|501-01-01-03
501-01-01-04	501-01-01	501|501-01|501-01-01|501-01-01-04

No matter what I do I get the error:

Couldn't load the visual data for this visual

Calculation error in measure. A table of multiple values was supplied where a single value was expected.

Thanks for you help

[amitchandak]

 If possible please share a sample pbix file after removing sensitive information.
Thanks

[Sebski]

Hi,

no problem here are the links to the pbix and sample data

Data

pbix  

Seb

[amitchandak · Accepted solution]

I created it as a new column instead of a measure and it worked. Power bi document does not say it needs to be created a column specifically but before example, the text says "The following example creates a calculated column that lists all the managers for each employee."

Refer

https://docs.microsoft.com/en-us/dax/path-function-dax