Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
Solved! Go to Solution.
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
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
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,
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
If you pull just the measure [Client Services BT %] into your matrix what does it return on the other rows?
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
122 | |
101 | |
71 | |
61 |