combine measures

[PipRon7]

Hi,

I have mulitple measures that use the AVERAGEX calculation to give me a Billable Target %.  These show as below:

I have an exisiting visual that uses various data columns as below:

what I would like to do is use the measures in step 1 in the exsiting matrix view to give the below result:

Is this possible and if so, what is the best way to achieve this?

Many thanks,

[v-chuncz-msft]

@PipRon7 

You may take advantage of column total and try ISINSCOPE to add a measure.

Measure 3 =
IF ( ISINSCOPE ( 'Table'[Column2] ), [Measure], [Measure 2] )

[PipRon7]

Hi @v-chuncz-msft 

Thanks for ther help and using the below code:

% Billing Target = 
IF ( ISINSCOPE ( 'YTD'[Department] ), [Client Services BT %])

I got the wanted result for client services as below:

I'm struggling to get it work for the other departments.... in how do i extend the ISINSCOPE to populate downwards for the other departments?

Any advice is much appreciated.