Displaying count value in the tooltip of a Gantt chart

[WinterGarden]

Hi All,

I've created a gantt chart as per below screenshot:

I've two tabels: Project , Project Task. There is a one - many relationship between these two tables(Project[Name]----Project Task[Project]).

I need to display the count of Task in the tooltip of this gantt chart. 

for eg: if Project[Name] = SP1 GOMBU, then the Task count  = 6  ie. sum of Project Task[Task]
Project[Name] = GOMBU PW Template , then the Task count  = 4
Project[Name] = DN Demo Template , then the Task count  = 2

Not able to add a measure in the tooltip, so i created a calculated column, but it is not giving the correct count.

Total Task Count = CALCULATE(COUNT('Project Task'[Task]),Project[Name] = SELECTEDVALUE('Project Task'[Project]))

could you please help me with this dax, to display the correct Task count

[Anonymous · Accepted solution]

Hi @WinterGarden ,

Here is my sample data:

Use this DAX to create a calculated column:

Total Task Count = 
CALCULATE(
    COUNTROWS('Project Task'),
    ALL('Project Task'),
    'Project Task'[Project] = EARLIER('Project Task'[Project])
)

And the final output is as below:

Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[WinterGarden]

@Anonymous ,
Thank you so much 😊