Showing results for 
Search instead for 
Did you mean: 
Post Patron
Post Patron

(Paginated Report/ErrorCode: rsFieldReference) Getting COUNTROWS of different dataset from a tablix

Bit boggled by this, I'm trying to get the COUNTROWS of a separate dataset from a tablix but keep running into the rsFieldReference error:


The Value expression for the text box 'Textbox21' refers to the field 'DateStart'.  Report item expressions can only refer to fields within the current dataset scope or, if inside an aggregate, the specified dataset scope. Letters in the names of fields must use the correct case.



This is the formula in question:


IIF(CDATE(Fields!Date.Value) >= CDATE(Fields!DateStart.Value) AND CDATE(Fields!Date.Value) <= CDATE(Fields!DateEnd.Value), 1, 0),



Any way I can resolve this? The main dataset I'm pulling the DateStart/DateEnd dates is a SQL query and the dsHolidayData dataset is from a PBI dataset connection so I don't think there's a way to do this via a query.

Community Support
Community Support

Hi @olimilo ,

Test to delete existing dataset and designed report and re-create it.

Similar question refer: 


Did I answer your question? Mark my post as a solution!

Best Regards


Helpful resources

Winner of T-Shirt Design

Power BI T-Shirt Design Challenge 2023

Find out who won the T-Shirt Design Challenge and the top 3 finalists.

March 2023 Update3

Power BI March 2023 Update

Find out more about the March 2023 update.

Top Solution Authors