How do I filter a table chart by condition

[ss35]

I would like to only display the rows of the table where the date field is greater than or equal to 01/01/2017.

[MartW]

what you are showing in screenshot 9 is the caculation condition, this calculation calculates if the chart will show or not.

for what you to filter in a chart, you can use set analysis for this. What you need to do is add a set analysis statement into a measure.

a set analysis statement looks something like this. 

sum ( { < DATEFIELD={'01-01-2017'} > } Expression )

[Danri94]

How can i adapt that statement if i want to see the Dates that are in the future (Date greater than today)?

[MartW]

sum ( { < DATEFIELD>={'01-01-2017'} > } Expression ) should work

[anat]

sum({<Date = {">=07/01/2020"}>} sal)

[gomeri]

Hello,

you need to insert in Calculation codition this formula of Set Analysis: 

SUM({<amazon.date>={'01/01/2017'}>} Date)

[ss35]

This is the result if I create a measure and add the above set analysis statement into the expression.

Where should I be adding the set analysis statement to filter the table chart?

Thank you.

[zhaofeng]

Build a variable named v_Date.The defination is   =makedate('2017','01','01')

Set a calculate dimension: =if(amazon.date>=$(v_Date),amazon.date)

If you do not want to write a calculate dimension,you can also write your expression like below

sum({<amazon.date={">=$(v_Date)"}>}[Your Measure Field])