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 Status Due Date 1 Completed mm/dd/yyy 2 Completed mm/dd/yyy 3 Not...
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

     

     

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