Filtering a measure

[susanjac]

Hi,

I would like to filter out a set of dates created as measures from a table. Please help me with this.

Dimension is ticket ids from JIRA tool and dates are pulled out from JIRA with formula using set analysis. Using if function I have highlighted certain items in red by comparing two dates derived using set analysis. I would like to filter out the ones highlighted in red. 

Any way to do it?

Thanks in advance.

[agigliotti]

Hi @susanjac ,

How does your measure expression looks like?

[susanjac]

Hi,

My expression looks like Max({<'conditions'>} 'date field from JIRA')

[agigliotti]

you should use a calculated dimension, you can't filter on measures value.

[sonkumamon]

Agigliotti is right. You need to create a new field for those dates in the script.

For example:

If(Match([PB Approval], 04 Nov 2020, 30 Dec 2020),[PB Approval]) as [PB Approval Calc]

and use this field for you measure.