Calculate Count Tasks by Resource with DateStart and DateEnd

[tquaresma]

Hi,

I need your help to calculate 3 metrics based on the shared data in the image.

I've tried several ways but I can't find a solution. 😞

Thank you for your help!

[Greg_Deckler]

So, you should be able to use a pattern like:

Tasks to Start = 
VAR __date = MAX([Slicer Date])
VAR __table = FILTER('Table',[TaskPercentageComplete]=0 && [TaskStartDate]>__date)
RETURN
COUNTROWS(__table)

[tquaresma · Accepted solution]

@Greg_Deckler  thanks! 😉

it works perfectly!