Count the number of clients based on one condition

[Ashish Mathur]

Hi,

I have a Pivot Table where I dragged financial years to the column labels. I am trying to determine the number of clients in each financial year which have given me business for >= past 4 financial years

I wrote the following calculated Field formula for it but nothing gets returned

=COUNTROWS(FILTER(SUMMARIZE(Feedback,ROLLUP([Organised by],Calendar1[FiscalYearKey]),"Years_of_business",[Clients visited]),[Years_of_business]=4))

Clients visited have been computed with the following calculated Field formula

=CALCULATE(DISTINCTCOUNT([Organised by]))

There is no error in the first formula but nothing is returned in the Pivot Table.

Please help.

Thank you.