Add dimension to 2 measures on same record

[radruss15]

I have 9 tables of data with costs:

Act Material Cost	Est Material Cost	Quote Material Cost
Act Labor Cost	Est Labor Cost	Quote Labor Cost
Act Sub Contract Cost	Est Sub Contract Cost	Quote Sub Contract Cost

I have put a cost type column in each table (Material, Labor, Sub Contract). They are all linked to a job lookup table and a cost type lookup table. I have measures that total Act Costs, Est Cost, and Quote Costs so I can get a nice table like this (filtered for an individual job)

Is there a way to use a DAX expression to split the data from the labor tables into 2 dimensions based on the value of the cost type?

[v-kelly-msft]

Hi @radruss15 ,

Many functions may meet,such as "filter","summarize","group by",can you show me more details?

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

[bfernandez]

I am a bit confused by your question, what are you trying to make it look like exactly?

I may have a solution which is to use the SWITCH DAX function.

Check out the documentation here.

I would use the function to seperate it into the categories you need, and then apply it to your rows.

[Anonymous]

I agree with @bfernandez , give a desired output because the question is difficult to follow