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

PipRon7's avatar
PipRon7
Frequent Visitor
7 years ago

Anonymous 

 

As you mentioned the main issue I am having is that currently my forumla is calculating the value only for the client services therefore I am able to see the data in my table for client services only and adding blank for rest of the departments.

 

I do not have the knowledge to extend my formula to include the other departments?  Can you advise on how I could extend the formula to include those?

 

Thansk,

 

Anonymous's avatar
Anonymous
Not applicable
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