Calculating Job Costs from ERP Job Table...

[hardy0411]

I need some help with figuring out how to calculate the total job cost from our ERP job cost table. The structure of the table has a column called "Job", a column for "Subjob", and a column for "Job Cost". Depending on the hierachy structure of the job, there can be multiple parent-child relationships to for the job strucutre (see below).

[v-chuncz-msft · Accepted solution]

@hardy0411 

You may try SUM to add a measure and take a look at Using drill down with the matrix visual.

[parry2k]

@hardy0411 you need to provide sample data with example output. Read this post to get your answer quickly.

https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490