Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Combine multiple measures into one

Hi, 

 

I have 4 measure within my table of which outputs 4 different columns with the correct values. What I would like to do is tidy up this table and essentially have these values from the 4 measures, into the one column, but not too sure how I can do that. Is it possible, please?

 

Here are the 4 measures:

 

costing_app = CALCULATE(SUM(fact__dorm_cost[dorm_val]), costing_app_code[exc_status]="Yes")
 
costing_comp = CALCULATE(SUM(fact__dorm_cost[dorm_val]), costing_comp _code[exc_status]="Yes")
 
costing_existing = CALCULATE(SUM(fact__dorm_cost[dorm_val]), costing_existing_code[exc_status]="Yes")
 
costing_set = CALCULATE(SUM(fact__dorm_cost[dorm_val]), costing_set_code[exc_status]="Yes")
Need Help
  • v-xiaotang's avatar
    v-xiaotang
    4 years ago

    Hi Anonymous 

    Thanks for reaching out to us.

    Please try this,

    measure=
var _costing_app = CALCULATE(SUM(fact__dorm_cost[dorm_val]), costing_app_code[exc_status]="Yes")
var _costing_comp = CALCULATE(SUM(fact__dorm_cost[dorm_val]), costing_comp _code[exc_status]="Yes")
var _costing_existing = CALCULATE(SUM(fact__dorm_cost[dorm_val]), costing_existing_code[exc_status]="Yes")
var _costing_set = CALCULATE(SUM(fact__dorm_cost[dorm_val]), costing_set_code[exc_status]="Yes")
return switch(true(),
_costing_app<>blank(),_costing_app,
_costing_comp<>blank(),_costing_comp,
_costing_existing<>blank(), _costing_existing,
_costing_set<>blank(), _costing_set)

     

     

    Best Regards,

    Community Support Team _Tang

    If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

3 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    4 years ago

    Anonymous , The information you have provided is not making the problem clear to me. Can you please explain with an example?

     

    You can combine the filters

     

    costing_app = CALCULATE(SUM(fact__dorm_cost[dorm_val]), costing_app_code[exc_status]="Yes" , costing_comp _code[exc_status]="Yes" , costing_existing_code[exc_status]="Yes") , costing_set_code[exc_status]="Yes")
    Appreciate your Kudos.


    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      This is my test table to show as an example. As you can see, I have the 4 columns, but highlighted in Blue, is what I am after, so I can just had the ID and NEW_COLUMN. 

      I have tried your suggestion as above, but the NEW_COLUMN is all blank.

       

      • v-xiaotang's avatar
        v-xiaotang
        Icon for Community Support rankCommunity Support
        4 years ago

        Hi Anonymous 

        Thanks for reaching out to us.

        Please try this,

        measure=
var _costing_app = CALCULATE(SUM(fact__dorm_cost[dorm_val]), costing_app_code[exc_status]="Yes")
var _costing_comp = CALCULATE(SUM(fact__dorm_cost[dorm_val]), costing_comp _code[exc_status]="Yes")
var _costing_existing = CALCULATE(SUM(fact__dorm_cost[dorm_val]), costing_existing_code[exc_status]="Yes")
var _costing_set = CALCULATE(SUM(fact__dorm_cost[dorm_val]), costing_set_code[exc_status]="Yes")
return switch(true(),
_costing_app<>blank(),_costing_app,
_costing_comp<>blank(),_costing_comp,
_costing_existing<>blank(), _costing_existing,
_costing_set<>blank(), _costing_set)

         

         

        Best Regards,

        Community Support Team _Tang

        If this post helps, please consider Accept it as the solution to help the other members find it more quickly.