Paginated Report Issue

[GuestUser]

Hi,

we are creating a paginated report
Data Source is SSAS Tabular
We have created measures in ssas

this is the format of report created
(hierarchy wise - expand and collapse)

                                                          2020
                                                           jan                                                  Feb
Department         Category        Week1 Week2 Week3               Week 1 Week2 Week3
Drinks                        abc                 10    20       30                        11        22       33

Have done the grouping and visibility set accordingly

When I just select year and month and do the grouping - the values come correct

But when i add week column - the monthwise total is not the addition of all weeks , it randomly picks up any one week value

Any suggestions pls

[Anonymous]

Hi @GuestUser ,

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

Best Regards

Rena

[Anonymous]

Hi @GuestUser ,

Please check if the following links can help you resolve your problem. 

Dax for Power BI: Fixing Incorrect Measure Totals

Power BI: Totals Incorrect

How to Calculate Percentage of Total in Matrix in Power BI

If 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 Regards

Rena

[Greg_Deckler]

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