Forum Discussion
Advocate IMeasure displays incorrect value in paginated report
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-builder-which-was-created/m-p/1572045
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?
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.
1 Reply
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.