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

0 votes
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?
Apr 2, 2019 in Tableau by nikki
2,475 views

1 answer to this question.

0 votes
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.
answered Apr 2, 2019 by Cherukuri
• 33,030 points

Related Questions In Tableau

0 votes
1 answer

How do I create a bubble chart that is aligned in Tableau?

Put your dimension in the column shelf Put ...READ MORE

answered Apr 18, 2022 in Tableau by Neha
• 9,020 points
1,193 views
0 votes
1 answer
0 votes
1 answer

Is it possible to create a hierarchy drill down using pie charts in Tableau

Hey Gowri, Regarding your doubt, you can go ...READ MORE

answered Feb 17, 2020 in Tableau by Gitika
• 65,770 points
2,045 views
0 votes
1 answer

Reset filters in Tableau

I understood your question (I hope so!). ...READ MORE

answered Mar 30, 2018 in Tableau by QueenBee
• 1,820 points
4,060 views
0 votes
1 answer

How to create a global filter

Assuming you have created a dashboard already, ...READ MORE

answered Apr 13, 2018 in Tableau by QueenBee
• 1,820 points
1,493 views
0 votes
1 answer

How can I create a second sheet which is filtered to 8 days ago,

Following are the steps you can follow: Create ...READ MORE

answered Jul 11, 2018 in Tableau by ffdfd
• 5,550 points
905 views
0 votes
1 answer

How to filter/parameter for different date ranges

Steps: Create a parameter control that the users ...READ MORE

answered Jun 21, 2018 in Tableau by Atul
• 10,240 points
5,079 views
0 votes
1 answer

In Tableau, how to pass measure/dimension to action filters that are not in the chart?

Hi Sindhu,  You can choose the fields that are ...READ MORE

answered Mar 11, 2019 in Tableau by Cherukuri
• 33,030 points
5,596 views
0 votes
1 answer

What is pivot in Tableau? how to create a pivot?

HI, When the data required is present in ...READ MORE

answered Jun 12, 2019 in Tableau by anonymous
• 33,030 points
1,201 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP