Combine multiple measures into one

[Anonymous]

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")

[amitchandak]

@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]

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 · Accepted solution]

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.