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

Question

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?

Answer 1

Hey @Ghost,

Why don't you use Level of Detail Expressions?

Create a calculated field for m1 and m2 measures:

{FIXED [Year]: SUM(m1)}