Forum Discussion
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.
let me know if this works.
Thanks,
Tejaswi
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