DAX Query

[SMisquith]

I have a column "Status" that contains values "completed" and "not completed"

I have a due date column 

Task	Status	Due Date
1	Completed	mm/dd/yyy
2	Completed	mm/dd/yyy
3	Not Completed	mm/dd/yyy

I want to visualize sum of all tasks completed/ sum of all tasks due for that month

I've written this query that has too many arguments

Percentage complete = CALCULATE(COUNT(Append1[Status],FILTER(Append1,Append1[Status]="Complete")/SUM(Append1[Completed/Not completed])))

[Fowmy]

@SMisquith 

Try this measure please:

Measure = 
DIVIDE(
    CALCULATE(
        COUNTROWS(Table1),
        Table1[Status] = "Completed"
    ),
    COUNTROWS(Table1)
)

[SMisquith · Accepted solution]

Thank you. The query seems to work, but I am unable to visualize it by due date