Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
Sebski
Regular Visitor

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

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-01501501|501-01
501-01-01501-01501|501-01|501-01-01
501-01-01-01501-01-01501|501-01|501-01-01|501-01-01-01
501-01-01-02501-01-01501|501-01|501-01-01|501-01-01-02
501-01-01-03501-01-01501|501-01|501-01-01|501-01-01-03
501-01-01-04501-01-01501|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

1 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

View solution in original post

3 REPLIES 3
amitchandak
Super User
Super User

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

Hi,

 

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

 

Data

pbix  

 

Seb

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

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors