Could you please attach mocked up sample data as twbx.
if [Geography] = 'U.S. Average'
Your Geography filter is being processed before your calculated field and returning a null value if you have a different geography value selected. By using a FIXED LOD calc, it will be evaluated before your filter.
Let me know how this works out for you.
The expression is returning US Average as 9.02 % percentage whereas actual US average is 1.89%, please have a look at below screenshots. This is because It is calculating it for All the years and not for year selected(which in this case 2014), Is there any way to make Year selection applicable on it?
If I only use if condition then it shows 1.89% but again it disappears as soon as I deselect U.S.Average
Thank you so much for the prompt reply, your suggestion worked!
Appreciate your help!
I Fixed the Year dimension, now its working
if [Geography] == 'U.S. Average' then
Thank you Sinichiro for your reply, the query has been resolved/
Perfect! Glad you got it working Rohit! And happy to help!