Forum Discussion

SMisquith's avatar
SMisquith
Frequent Visitor
5 years ago
Solved

DAX Query

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

I have a due date column 

Task

StatusDue Date
1

Completed

mm/dd/yyy
2Completedmm/dd/yyy
3Not Completedmm/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])))
Need Help
Tips and Tricks
  • SMisquith's avatar
    SMisquith
    5 years ago

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

     

     

2 Replies

  • Fowmy's avatar
    Fowmy
    Super User
    5 years ago

    SMisquith 

    Try this measure please:

    Measure = 
DIVIDE(
    CALCULATE(
        COUNTROWS(Table1),
        Table1[Status] = "Completed"
    ),
    COUNTROWS(Table1)
)
    • SMisquith's avatar
      SMisquith
      Frequent Visitor
      5 years ago

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