Forum Discussion

bgashok's avatar
bgashok
Helper I
2 years ago
Solved

Deviation & comitted calcuation

I am trying to calculate Deviation  & comitted calculation    Comitted graph: x-axis : number of Tasks closed on last day (11/7/23) of iteration from committed (closed state ) / (number of tasks pl...
Need Help
  • amitchandak's avatar
    amitchandak
    2 years ago

    bgashok , Please find the measures you need

     

    Task Planned = Sumx(Table2, CountX(filter(Table1, Table1[Iteration] = Table2[Iteration] && Table2[Start Date]= Table1[ calendar Date] && [State] <> "closed"), Table1[ID]))

Task Closed = Sumx(Table2, CountX(filter(Table1, Table1[Iteration] = Table2[Iteration] && not(ISBLANK(Table1[Closed Date  ])) && Table1[Closed Date  ] = Table2[End Date] && Table1[ID] in SUMMARIZE(filter(Table1, Table1[Iteration] = Table2[Iteration] && Table2[Start Date]= Table1[ calendar Date] && [State] <> "closed"), Table1[ID])), Table1[ID]))

     

     

     

    File attached after signature

amitchandak's avatar
amitchandak
Super User
2 years ago

bgashok , Please find the measures you need

 

Task Planned = Sumx(Table2, CountX(filter(Table1, Table1[Iteration] = Table2[Iteration] && Table2[Start Date]= Table1[ calendar Date] && [State] <> "closed"), Table1[ID]))

Task Closed = Sumx(Table2, CountX(filter(Table1, Table1[Iteration] = Table2[Iteration] && not(ISBLANK(Table1[Closed Date  ])) && Table1[Closed Date  ] = Table2[End Date] && Table1[ID] in SUMMARIZE(filter(Table1, Table1[Iteration] = Table2[Iteration] && Table2[Start Date]= Table1[ calendar Date] && [State] <> "closed"), Table1[ID])), Table1[ID]))

 

 

 

File attached after signature