Hi I Created a number formatting in load script
Load *
inline [
NUMBER_FORMAT, Qnum
0, '#,##0'
1, '#,##0.0'
2, '#,##0.00'
0&,'#,##0'
1&,'#,##0.0
2&, '#,##0.00'
2%, '#,##0%'
3%, '#,##0.0%'
4%, '#,##0.00%'
];
num(sum(A),Qnum)
and trying to apply it to my measure . all except "%" ones seems to work until I apply Filter. Any thoughts why?