Paginated Report HELP! Not showing the same as PowerBI

[lliu_western]

Hello community, 

I am very very stuck for a long time now. I have a very complicated measure and I am going to simply it in my explanation, hopfully I can still get the point across.

In my PowerBI report, I have a piviot table similar to below:

	Hours	Percentage Value
January	2294	0.72
February	1939	0.71
March	2095	0.71
April	2055	0.72
May	2164	0.79
June	1773	0.79
July	345	0
August	230	0
September	0	0
October	0	0
November	0	0
December	0	0
TOTAL	12865	71

(The Total is the sub-total calculation in PowerBI) 

Please note that, the "Total" In "Percentage Value" is calculated by SUM(Hours * percentage value  in each row) / Total Hours

So [(2294 * 0.72) + (1939*0.71) + (2095*0.71) ......  ] / 12865

However, when I try to call the Total in Percentage Value in Paginated Report, I cannot get the 71 value... the value will always just equal to the earliest "percentage value" in the selected parameter. In the example above, the total will appear to be "72" instead of 71.

Any help will be really appreciated.

Thank you! 

[lliu_western · Accepted solution]

Hi community, 

I found the solution to my own question and it works in Paginated report as well. I just have to call that value in Paginated report. 

I used TOTALYTD(CALCULATE([the monthly measure I already create ]. ALLEXCEPT(Table,Table[Date - Uear], 'Filter' [All the columns that I want to keep the filter on])),DateTable[Date])

so instead of using ALLSELECTED, I used ALLEXCEPT to ignore the filters in the pivot table then use "TOTALYTD" to keep the date filter of this year again. 

[Anonymous]

Hi @lliu_western ,

This is Nishanth , I am also facing the similar issue with Paginated report.

I have created matrix visual in Power BI which shows sales & YOY growth percentage.

YOY Growth formula  = var ab= caluculate([sale],dateadd(dates,-1,year))
                                                   return
                                        divide(([sale]-ab),ab))

I have a requirement to create paginated report on it. Its working fine with the sales, But not working with the YOY percentage (showing wrong values: showing earliest value in the selected region)).

can you please help me with this issue?

[amitchandak]

Thanks for sharing. Kudos !!

[amitchandak]

Try like

averagex(summarize(table,table[Month],"_Hours",[hours],"_Per",[Percentage Value]),[_Hours]*[_Per])