Hi there,
I have a specific strange thing about Slice and I would like to seek your help.
Issue and background:
1.user change a report measure from ‘Amout (M) (HKL Share)’ to ‘Amout (M) (100% Basis)’, the report data area become blank, but when she switch back to ‘Amout (M) (HKL Share)’ , data back… another cube got same error, measure name also contain (100% Basis).
2.user can view all ‘Amout (M) (HKL Share)’ and ‘Amout (M) (100% Basis)’ data in cube… Can snapshot/slice the report.
3.so far only this user meet this issue, consultant/Power User/ 2 other normal users didn’t encounter this problem and cannot reproduce it
4.can view data: move measure dimension from title to column
5.can’t view data: grant user ‘ADMIN’ access, change dimension filter order, expand children
6.Excel ver:2605 Build 16.0.20026.20166
7.Slice ver:5.3.0.0
Detail please refer to the video (please contact me to share the video link) and timeline fyi
Any ideas and thoughts provided would be greatly appreciated! 
00:00 open Auto Recalculate, and rebuild sheet, start to demo
00:40 showing Measure: ‘Amout (M) (HKL Share)’, can see data
Switch to Measure : ‘Amout (M) (100% Basis)’, both picklist and data blank, but subnm formula correct: SUBNM(“Server:M DP Management Account”, “Default”," “Amout (M) (100% Basis)”)
01:00 try to change other dimension filter, no problem
02:20 pull Measure Dimension to Column area, can see both ‘Amout (M) (HKL Share)’ and ‘Amout (M) (100% Basis)’ data
04:18 expand ‘Amout (M) (HKL Share)’ and ‘Amout (M) (100% Basis)’ down to N level
04:41 all 100% basis related measure not work
06:42 Excel Version
07:41 change the order of dimension, move Measure after Year dimension
08:00 still got blank, but we see data flash???
09:26 grant user ADMIN access and try again
11:29 got ADMIN right , still facing same issue
12:49 Try another cube:FIN Management Report, all 100% basis related measure not work
