Forum Discussion

humid's avatar
humid
Frequent Visitor
3 years ago

Paginated Report not distributing Count values correctly

Hello,   I've just started to work a bit with Report Builder with our Power BI Report Server and although I've done some progress, I'm right now stuck with a requeriment which is so simple in Power...
COUNT
Paginated Report
Power BI Desktop RS
report builder
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi humid ,

For create paginated report in report builder, if you create matrix visual, you can set the aggregation type by select during design time.

For more details, you can read related document: Tutorial: Creating a Matrix Report (Report Builder) - SQL Server Reporting Services (SSRS) | Microsoft Learn

 

Best regards,
Community Support Team_ Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

humid's avatar
humid
Frequent Visitor
3 years ago

Hello, when I create the Matrix i receive the following error:

 

The expression used for the calculated field 'Metric_01' includes an aggregate, RowNumber, RunningValue, Previous or lookup function. Aggregate, RowNumber, RunningValue, Previous and lookup functions cannot be used in calculated field expressions.

 

Metric_1 = CountDistinct ( IIF
( Fields!Diff.Value > 0 And Fields!Action_Phase.Value <> "Complete" And Fields!Action_Phase.Value <> "Void",Fields!Number.Value,Nothing),"DataSet1")

 

Any help?