Forum Discussion

radruss15's avatar
radruss15
Regular Visitor
6 years ago

Add dimension to 2 measures on same record

I have 9 tables of data with costs:

Act Material CostEst Material CostQuote Material Cost
Act Labor CostEst Labor CostQuote Labor Cost
Act Sub Contract CostEst Sub Contract CostQuote 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?

Need Help

3 Replies

  • bfernandez's avatar
    bfernandez
    Icon for Resolver II rankResolver II
    6 years ago

    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's avatar
      Anonymous
      Not applicable
      6 years ago

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

  • v-kelly-msft's avatar
    v-kelly-msft
    Icon for Community Support rankCommunity Support
    6 years ago

    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!