LOD expressions- Create a calculation that is not affected by filters

Question

I want to view the sales of a country vs its region and all countries and sales. I have added a filter for country to compare country and region wise sales.

I added a lod like this { FIXED [Country] : SUM([Sales]) }

But wrong values are shown for it. Can someone help me?

Answer 1

Hi Nikki,

Your LOD expression is correct, but the filter does not affect your field (from LOD expression).
Thus what you have to do is to convert the filter to context filter.

To convert to context filter, Right click on the filter field and click on add to context.
Thus the filter would be sensitive to created through LOD expression.
For suppose, if you want to show country sales wrt all selected from filter from same region, then convert filter to context.
You would observe the difference, that the total changes from after and before adding to context.
Hope this helps you.