Deploy the attached database. Connect under a user in the US role. Note the role has dimension data security so the user can only see details about US countries/cities/PostalCodes. But the "visual totals" checkbox isn't checked so the grand total should still be the real grand total.MDX queries under users in that role do properly show the real grand total: 60,398select [Measures].[Order Quantity] on 0,[Geography].[By State].[State].Members + [Geography].[By State].[All] on 1from [Adventure Works]However the DAX queries generated by Power View don't property show the real grand total:EVALUATE CALCULATETABLE( ROW( "Order_Quantity", 'Internet Sales'[Order Quantity] ), KEEPFILTERS( FILTER( KEEPFILTERS(VALUES('Geography'[State 2.UniqueName])), NOT(ISBLANK('Internet Sales'[Order Quantity])) ) ) )EVALUATE ADDCOLUMNS( KEEPFILTERS( FILTER( KEEPFILTERS( SUMMARIZE(VALUES('Geography'), 'Geography'[State 2.UniqueName], 'Geography'[State 2]) ), NOT(ISBLANK('Internet Sales'[Order Quantity])) ) ), "Order_Quantity", 'Internet Sales'[Order Quantity] )ORDER BY 'Geography'[State 2], 'Geography'[State 2.UniqueName]
Product Language
Version
Category
Operating System
Operating System Language
Steps to Reproduce
Actual Results
Expected Results
Platform
Virtualization
Please wait...