Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
PipRon7
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
Anonymous
Not applicable

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
Anonymous
Not applicable

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

 

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
Not applicable

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

@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
Not applicable

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

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

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.