How to Make filter work with set analys

[Ravi_Nagmal]

Hi All,

I have created a measure with the help of set analysis to calculate last year revenue is user selects current year.

I am facing an issue is I have some filter like "Client_ID" and "Client_Type" If user select any values from this filter then that numbers to reflect current this number is not changing with any filter.

({1}{<Received_Date= {">=$(=Min(addmonths(addmonths(Received_Date,0,4),-12)))<=$(=Max(addmonths(Received_Date,-12)))"}> }
SUM(if(match( assignment_current_state,'Assignment') and match(is_rr_inquiry,'No') and match(Identifier,'Base_Table'),[USD Total Fees])))

[jochem_zw]

try this:

({$}{<Received_Date= {">=$(=Min(addmonths(addmonths(Received_Date,0,4),-12)))<=$(=Max(addmonths(Received_Date,-12)))"}> }
SUM(if(match( assignment_current_state,'Assignment') and match(is_rr_inquiry,'No') and match(Identifier,'Base_Table'),[USD Total Fees])))

[Ravi_Nagmal]

Thanks @jochem_zw for prompt reply.

Filters are working now but for Fiscal year is not working now

[Aasir · Accepted solution]

({1< Client_ID = P(Client_ID), Client_Type = P(Client_Type) >}
{< Received_Date = {">=$(=Min(addmonths(addmonths(Received_Date,0,4),-12)))<=$(=Max(addmonths(Received_Date,-12)))"} >}
SUM(
if(
match(assignment_current_state, 'Assignment') and
match(is_rr_inquiry, 'No') and
match(Identifier, 'Base_Table'),
[USD Total Fees]
)
))

[Aasir]

({$<Fiscal_Year=P(Fiscal_Year)>}
{<Received_Date={">=$(=Min(addmonths(addmonths(Received_Date,0,4),-12)))<=$(=Max(addmonths(Received_Date,-12)))"}>}
SUM(
if(
match(assignment_current_state, 'Assignment') and
match(is_rr_inquiry, 'No') and
match(Identifier, 'Base_Table'),
[USD Total Fees]
)
))

[Ravi_Nagmal]

@Aasir This is working properly but i am getting less numbers then expected. What would be the reason ?

({1< Client_ID = P(Client_ID), Client_Type = P(Client_Type) >}
{< Received_Date = {">=$(=Min(addmonths(addmonths(Received_Date,0,4),-12)))<=$(=Max(addmonths(Received_Date,-12)))"} >}
SUM(
if(
match(assignment_current_state, 'Assignment') and
match(is_rr_inquiry, 'No') and
match(Identifier, 'Base_Table'),
[USD Total Fees]
)
))