Is it possible to apply filter just to one of the measures

0 votes

What I did?

I had a Tableau workbook consisting of 3 measures m1,m2 and m3. Following table is generated once you aggregate the fields by year and sum them up.


|     |     2017        |     2018     |
----------------------------------------
| m1  |      10        |      20       |
----------------------------------------
----------------------------------------
| m2  |      10        |      20       |
----------------------------------------
----------------------------------------
| m3  |      10        |      20       |
----------------------------------------

What I want?

I want to apply a date filter to variable m3 so that the resulting table looks similar to the one above (but in the background m3 data is filtered.)

I want something like this:

if metric == m3 then filter(year)

Does anyone know how to achieve this in Tableau?

Apr 17, 2018 in Tableau by ghost
• 1,790 points
1,465 views

1 answer to this question.

0 votes

Hey @Ghost,

Why don't you use Level of Detail Expressions?

Create a calculated field for m1 and m2 measures:

{FIXED [Year]: SUM(m1)}
answered Apr 17, 2018 by Atul
• 10,240 points

Related Questions In Tableau

0 votes
1 answer

Is it possible to change the order of parameters in the dashboard?

Yes it is possible, you can try ...READ MORE

answered May 17, 2018 in Tableau by Abraham1990
809 views
0 votes
1 answer

Is it possible to join tables on the basis of some calculated field in Tableau?

@Ammy999, You can not perform join in the ...READ MORE

answered May 17, 2018 in Tableau by Mathew1810
1,380 views
0 votes
1 answer
0 votes
1 answer

Is it possible to do a % of Table with an attribute in Tableau?

Hi Nithin, yes it is possible to ...READ MORE

answered Mar 12, 2019 in Tableau by Cherukuri
• 33,030 points
1,411 views
0 votes
1 answer

Getting incorrect tooltip while toggling through quick filter

I think what you want to ask ...READ MORE

answered Jun 27, 2018 in Tableau by ffdfd
• 5,550 points
766 views
0 votes
1 answer

Create global filter from single/multiple data source to multiple data sources on dashboard.

Hi Sindhu, You can use filters from worksheets in ...READ MORE

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

create filter from multiple data sources

Hi Nithin, 1. You can perform full outer ...READ MORE

answered Mar 13, 2019 in Tableau by Cherukuri
• 33,030 points
686 views
0 votes
1 answer

Using Top in filter.

Hi Tejas, The top filter is used to ...READ MORE

answered Apr 30, 2019 in Tableau by Cherukuri
• 33,030 points
648 views
+1 vote
1 answer

Is it possible to define a color code scheme just for one column in Tableau?

Follow the below steps : Remove your current ...READ MORE

answered Jul 24, 2018 in Tableau by Atul
• 10,240 points
2,562 views
0 votes
1 answer

Is it possible to connect ActivePlot to Tableau?

ActivePivot implements the standards of OLAP: The MDX ...READ MORE

answered Jul 10, 2018 in Tableau by Atul
• 10,240 points
725 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