Forum Discussion

c37582's avatar
c37582
Frequent Visitor
2 years ago

Paginated Reports: The aggregate function "Aggregate" cannot be used in report that contains filters

Hi guys,   First of all apologies if I'm not posting this in the right forum - I couldn't see any board for Power BI Report Builder.   Wondering if anyone out there is familiar with using the "Ag...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi c37582 ,

The error message suggests that there might be filters applied at some level in your report which are conflicting with the use of the "Aggregate" function. This could be filters applied directly on the dataset, on the tablix, or even as report parameters that influence the dataset query.

 

Ensure that the expression used for the "Aggregate" function is not combined with other functions that are not supported.

More details: Aggregate function in a paginated report - Microsoft Report Builder & Power BI Report Builder | Microsoft Learn

 

Best Regards
Community Support Team _ Rongtie

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

  • c37582's avatar
    c37582
    Frequent Visitor
    2 years ago

    Hi Anonymous ,

    Thanks for your reply. I don't have any filters on the tablix or report parameters. There are filters on the dataset, but as I said in my post there are filters on the dataset that is used in the "Paginated Reports in a Day" video as well and the function works fine. In any case, when I remove the filters from the dataset I still get the same error: