# Incorrect result of function

### Question

• Hi,

My objective is the compute "The number of clients in the current year with whom i have been transacting since the past three years".  I dragged financial year to the column area.  Thereafter, i wrote the following calculated Field formula

`=COUNTaX(FILTER(SUMMARIZE(SUMMARIZE(Feedback,Calendar1[FiscalYearKey],Feedback[Organised by],"client_visited_VA",[Clients visited]),Feedback[Organised by],"Summary of visits",[Clients visited]),[Summary of visits]=3),[Clients visited])`

There is no error when i click on Check Formula.  However, in the Pivot Table no data shows up.

As an alternative, i tried this calculated Field formula as well but once again just got all blanks

`=COUNTROWS(FILTER(SUMMARIZE(Feedback,Calendar1[FiscalYearKey],ROLLUP(Feedback[Organised by]),"client visited_VA",[Clients visited]),[client visited_VA]=3))`

[Clients Visited] have been computed with the following calculated Field formula

`=CALCULATE(DISTINCTCOUNT([Organised by]))`

Could you help me identify the error.

Thank you.

Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com

Saturday, March 09, 2013 4:33 AM

### All replies

• Hi,

This calculated Field formula also returned all 1's

`=COUNTROWS(FILTER(SUMMARIZE(Feedback,Calendar1[FiscalYearKey],ROLLUP([Organised by]),"client visited_VA",[Clients visited],"Sub_total_row",ISSUBTOTAL([Organised by])),[sub_total_row]=TRUE))`
Where am I going wrong?

Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com

Saturday, March 09, 2013 6:25 AM
• Ashish,

Have you made any progress with this?

Thanks!

Ed Price, Power BI & SQL Server Customer Program Manager (Blog, Small Basic, Wiki Ninjas, Wiki)

Answer an interesting question? Create a wiki article about it!

Tuesday, November 19, 2013 8:24 AM
• Hi,

Yes, I could solve the problem.  Thank you for following up.

Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com

Tuesday, November 19, 2013 8:26 AM
• Great! Do you know what the problem was?

Thanks!

Ed Price, Power BI & SQL Server Customer Program Manager (Blog, Small Basic, Wiki Ninjas, Wiki)

Answer an interesting question? Create a wiki article about it!

Sunday, November 24, 2013 1:11 AM
• Hi,

I do not really remember now.  I solved it quite some time back.  Thank you for following up.

Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com

Sunday, November 24, 2013 2:33 AM