powerbidax

power Bi count the number of completed tasks per bucket

I'm using power automate to export data from planner to Power Bi. I'm creating a report using a Gantt visual and one of the required variables is % Completion. I'm using buckets as the "project name" and want to know how to calculate the Number of tasks completed, not sure where or how exactly to achieve this. My tables are:

Buckets: id,name,description Tasks: id,name,bucketId,complete (100 or 0)

I reckon i could add a custom column or measure but i'm really lost on how to do this or even where this should be done exaclty

Solution

  • Assuming you have a relationship between the two tables, you could create a Measure with:

    Completed Tasks = 
  CALCULATE(
    COUNTROWS(Tasks),
    Tasks[complete] = 100
  )

    You can also use the same expression for a Calculated Column in the Buckets table.