Paginated Report Issue

Question

Hi,we are creating a paginated reportData Source is SSAS TabularWe have created measures in ssasthis is the format of report created(hierarchy wise - expand and collapse)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2020&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;jan&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; FebDepartment&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Category&nbsp; &nbsp; &nbsp; &nbsp; Week1 Week2 Week3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Week 1 Week2 Week3Drinks&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; abc&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;10&nbsp; &nbsp; 20&nbsp; &nbsp; &nbsp; &nbsp;30&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 11&nbsp; &nbsp; &nbsp; &nbsp; 22&nbsp; &nbsp; &nbsp; &nbsp;33Have done the grouping and visibility set accordinglyWhen I just select year and month and do the grouping - the values come correctBut when i add week column - the monthwise total is not the addition of all weeks , it randomly picks up any one week value&nbsp;Any suggestions pls&nbsp;

greg_deckler · Answer

This looks like a measure totals problem. Very common. See my post about it here: https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376

Also, this Quick Measure, Measure Totals, The Final Word should get you what you need:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/547907

anonymous · Answer

Hi&nbsp;GuestUser&nbsp;,Please check if the following links can help you resolve your problem.&nbsp;Dax for Power BI: Fixing Incorrect Measure TotalsPower BI: Totals IncorrectHow to Calculate Percentage of Total in Matrix in Power BIIf the suggestion/solution in above links can't resolve your problem, could you please provide some sample data(exclude sensitive data) and the formula of measures which applied on visual? It is better if you can provide these information with screen shots. Thank you.Best RegardsRena

anonymous · Answer

Hi&nbsp;GuestUser&nbsp;,Whether the problem has been resolved? If yes, could you please mark the helpful post as Answered? It will help other members&nbsp;in the community find the solution easily if they face the similar problem with you. Thank you.Best RegardsRena

Forum Discussion

Paginated Report Issue

3 Replies

Related content

Paginated Report

Paginated report issue

Issue with Paginated Report Access in Acumatica

Paginated report

Paginated Report Credentials Issue