Measure displays incorrect value in paginated report

[arca123]

Hello!
I am trying to build paginated report consisting of multiple row groups. I have a measure that I have imported from PBI dataset which I need to display for each row group. It is displayed correctly for the first group, but for second and third row group, the measure seemingly takes random result - sometimes it is displayed just as 0, sometimes it takes the largest result from the first row group.

This other forum post seems related to my problem https://community.fabric.microsoft.com/t5/Report-Server/How-to-use-measures-in-power-bi-report-build...

I believe if I add not the measure, but the whole calculated DAX formula to my query, it should work. But I couldn't figure out the syntax. The paginated report query I have is 
EVALUATE SUMMARIZECOLUMNS('Table1'[Column1],"MeasureName1",[MeasureName1]). I still need all these columns and measures. How can I add a DAX formula to this query?

Maybe there are other solutions for the problem I am having?

[Anonymous · Accepted solution]

Hi, @arca123 

It may be helpful to add the full DAX formula. You can modify the query to include the DAX formula directly.

EVALUATE
SUMMARIZECOLUMNS(
    'Table1'[Column1],
    "MeasureName1", CALCULATE(SUM('Table1'[YourMeasureColumn]))
)

Also make sure that the row context is set correctly for each group. Sometimes, using CALCULATE with the appropriate filters can help maintain the correct context.

Sometimes it helps to use expressions in the paginated report itself. For example, you can use the LOOKUP function to get the correct value from another dataset. You can refer to the following post:

Solved: Paginated Reports/SSRS not reporting calculated pe... - Microsoft Fabric Community

Ensure that any parameters used in the DAX formula are passed and handled correctly in the paginated report. You can check the following link:

Solved: Paginated report help using measure and parameter ... - Microsoft Fabric Community

How to Get Your Question Answered Quickly

Best Regards

Yongkang Hua

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