Forum Discussion

PipRon7's avatar
PipRon7
Frequent Visitor
7 years ago

combine measures

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 belo...
Need Help
Tips and Tricks
v-chuncz-msft's avatar
v-chuncz-msft
Community Support
7 years ago

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's avatar
PipRon7
Frequent Visitor
7 years ago

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.