Tooltop to display measure with no of responses by date

[Anonymous]

Hi,

This forum is doing great job for all levels. I entered into Power BI world from SSRS and learning lots of DAX scripting on the way.

I believe this will be the simplest queston someone has posted on this forum.  In the urgency of request I am not having any other option but to ask here. Can someone one please suggest if I want to display a tooltip which simply shows count of record date. 

tbl_Survey Data in summarise form is,

RecordDate	CountSurvey	AvgScore (0-10)
03/04/2020	20	5.3
08/04/2020	54	6.8
10/04/2020	45	4.9
12/04/2020	60	7

Line chart will nicely show four data points according to average score. I need to create a tooltip measure to show on that particular day how many surveyCounts are there. When I create measure it shows total SurveyCount which is 169, whereas requirement is to show tooltip what is surveycount on that particular record date. 

I tried these two measures

No of responses = SUM(tbl_Survey[CountSurvey])

Another measure I used is

  

No of responses by date =

VAR _date = SELECTEDVALUE(tbl_Survey[RecordDate])

VAR _result = CALCULATE(SUM(tbl_Survey[RecordDate]),

FILTER(tbl_Survey, _date = tbl_Survey[RecordDate]))

RETURN _result

Please let me know if I missed something to provide. 

Many thanks

[nandukrishnavs]

@Anonymous -

 

Is this expected output?

[Anonymous]

Yes that is right. Can you please share measure 's DAX code.

Regards

[nandukrishnavs]

@Anonymous  - 

Assuming that your table structure is similar to below.

I haven't used any measure. You can directly use columns into the visual fields.