Forum Discussion
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...
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
If you pull just the measure [Client Services BT %] into your matrix what does it return on the other rows?