Forum Discussion

PipRon7's avatar
PipRon7
Frequent Visitor
7 years ago
Solved

DAX ISINSCOPE Help

Hi,

 

I am using the below dax function:

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

That gives me the correct result of a billing target % for the client services department as below:

 

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

 

Any advice is much appreciated.

Need Help
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    7 years ago

    Hi PipRon7 ,

     

    Since you are calcuting average by category,

     

    Just use this Dax Measure to get what you want. you dont need other measures.

    % Billing Target = 
average(Sheet1[Billable Target %])

    My output based on the sample you provided.

    let me know if this works.

     

    Thanks,

    Tejaswi

6 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hi PipRon7 ,

     

    Do you mind in sharing the Sample data?

    Becasue I want to know whats the data in your [CLient Services BT %],

    It looks like your formula found only client services and returned blank for other departments.

    I can give a try with this if I have a sample data.

     

    Thanks,

    Tejaswi

     

    • jdbuchanan71's avatar
      jdbuchanan71
      Super User
      7 years ago

      If you pull just the measure [Client Services BT %] into your matrix what does it return on the other rows?

    • PipRon7's avatar
      PipRon7
      Frequent Visitor
      7 years ago

      Hi Anonymous 

       

      Here is a example of the data i am using - file example

       

      the logic i am using to create the  [CLient Services BT %] is:  

      Client Services BT % = AVERAGEX(FILTER('YTD','YTD'[Department]="Client Services"),'YTD'[Billable Target %])

       

      I am just looking for the best way to insert my various department BT %'s into my existing data visuals.

       

      Any help much appreciated

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        Hi PipRon7 ,

         

        Don't know why but I an unable to recreate your issue.

        I tried to calculate the Client Services %, but dont know if these is the correct formula you are using. 

        When I am using this formula it is not calculting the correct arithmetic means. So dont know if the formula you provided is correct.

         

        Also looking at the formula it calcualtes the value only for the client services therefore you are able to see the data  in you table  for client services only and adding blank for rest of the departments.

         

        You will have to provide me the exact steps you used , so that I can recreate the same in my system.

         

        Thanks,

        Tejaswi