Hello Saurabh, - I branched your discussion to a new thread. Let' see if we can get more eyes on this.
jpe - my buddy here :-) might be able to assist if he has a min.
Please mark the appropriate replies as CORRECT / HELPFUL so our team and other members know that your question(s) has been answered to your satisfaction.
I agree. You can use a calculated dimension to to do this.
If your dimension is: COUNTRY
and the measure is: SALES
Change the dimension to: if ( aggr(sum(SALES),COUNTRY) > 0 , COUNTRY)
... then ensure you select the checkbox to hide NULLs on the dimension.
You may also be able to do a dimension limit using the > 0 value as well.
Using aggr or Dimension limit is a great idea when we dont know which Dimension would give zero values!
When we know which Dimensions to ignore then we can directly use if(Dimension='A','B'...) or maybe pick(match())..
Quick Answer: We need to basically use Hide null property of Dimensions.