Filter issue on Measure

[Clint]

Hello,

I have the following measure that simply indicates via a "Y" or"N" if a task (Project Online dataset) is done or not.  These tasks (from the Tasks table)  live in a table visual on a page that the user drills thru to based on the Project Name field (from the Projects table).  The Projects table and Tasks table or connected in a One to Many relationship via the ProjectID field.

Task Done Y/N =

VAR TaskDone =SUMX('Tasks','Tasks'[TaskPercentWorkCompleted])

Return

CALCULATE(

IF(TaskDone=100,"Y","N"

)

The problem is adding this measre to the table results in the table returning all tasks instead of just the tasks from the project the user drilled thru on.  I know I need account for the project name filter but I don't know how to write this in the DAX.  I tried the below syntax but it doesn't workl

Task Done Y/N =

VAR TaskDone =SUMX('Tasks','Tasks'[TaskPercentWorkCompleted])

Return

CALCULATE(

ALLEXCEPT('Projects','Projects'[Project Name]),

IF(TaskDone=100,"Y","N"

))

[v-eachen-msft]

Hi @Clint ,

Could you please share your sample data and expected result to me if you don't have any Confidential Information? Please upload your files to OneDrive for Business and share the link here.

[Clint]

Hi @v-eachen-msft ,

We decided to use conditional formatting instead of a Y/N so this measure became a moot issue.

[Mariusz]

Hi @Clint 

Create a Column instead if you want the result to be part of a filter context.

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
LinkedIn

[Clint]

Doesn't Calculate introduce Filter context?