cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
PipRon7 Frequent Visitor
Frequent Visitor

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:Screen Shot 2019-07-19 at 10.22.03.png

 

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.

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
tejaswidmello Established Member
Established Member

Re: DAX ISINSCOPE Help

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.

Capture1.PNG

let me know if this works.

 

Thanks,

Tejaswi

View solution in original post

6 REPLIES 6
tejaswidmello Established Member
Established Member

Re: DAX ISINSCOPE Help

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

 

Super User
Super User

Re: DAX ISINSCOPE Help

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

PipRon7 Frequent Visitor
Frequent Visitor

Re: DAX ISINSCOPE Help

Hi @tejaswidmello 

 

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

tejaswidmello Established Member
Established Member

Re: DAX ISINSCOPE Help

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

PipRon7 Frequent Visitor
Frequent Visitor

Re: DAX ISINSCOPE Help

@tejaswidmello 

 

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,

 

Highlighted
tejaswidmello Established Member
Established Member

Re: DAX ISINSCOPE Help

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.

Capture1.PNG

let me know if this works.

 

Thanks,

Tejaswi

View solution in original post

Helpful resources

Announcements
New Ranks and Rank Icons in 2020

New Ranks and Rank Icons in 2020

Read the announcement for more information!

New Kudos Given Badges Coming

New Kudos Given Badges Coming

We're rolling out new Kudos Given badges. Find out how many Kudos you've given.

November 2019 Community Highlights

November 2019 Community Highlights

Get an overview of the events and great community content from November.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Solution Authors
Top Kudoed Authors (Last 30 Days)