Hi FreemanZ 

Thank you for promt response. I am connecting through direct query so we dont have any weekNo column. How to fetch weekNo as measure and then rewrite this query?

because Values function expecting a column value not measure.