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
20 views

1 answer to this question.

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.
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,220 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 16, 2018 in Tableau by Abraham1990
22 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 ...READ MORE

answered May 16, 2018 in Tableau by Mathew1810
65 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 in Tableau by CHERUKURI
• 15,460 points
14 views
0 votes
1 answer

Getting incorrect tooltip while toggling through quick filter

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

answered Jun 26, 2018 in Tableau by Atul
• 5,490 points
13 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 in Tableau by CHERUKURI
• 15,460 points
42 views
0 votes
1 answer

create filter from multiple data sources

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

answered Mar 13 in Tableau by CHERUKURI
• 15,460 points
11 views
0 votes
1 answer

Using Top in filter.

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

answered Apr 30 in Tableau by CHERUKURI
• 15,460 points
10 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 23, 2018 in Tableau by Atul
• 10,220 points
78 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 9, 2018 in Tableau by Atul
• 10,220 points
38 views

© 2018 Brain4ce Education Solutions Pvt. Ltd. All rights Reserved.
"PMP®","PMI®", "PMI-ACP®" and "PMBOK®" are registered marks of the Project Management Institute, Inc. MongoDB®, Mongo and the leaf logo are the registered trademarks of MongoDB, Inc.