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 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,

Need Help
Tips and Tricks

2 Replies

  • 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.