Ignoring selections in set analysis

[Gopi_E]

Hi All,

here i trying to ignore one field selection in set analysis, but still its taking selection from that field, here is my metrics

Sum({$<Month = {"$(='>=1<='& max(MonthNum))"}, Year = {"$(='>=2011<='& max(Year))"}, YearMonth= ,MonthNum=>}Sales)

above one taking selections from YearMonth and MonthNum fields,

can you please let me know what is wrong this expression

Thanks in advance

[Arthur_Fong · Accepted solution]

Try this:

Sum({$<Month = {"$(='>=1<='& max({1}MonthNum))"}, Year = {"$(='>=2011<='& max(Year))"}, YearMonth= ,MonthNum=>}Sales)

[Gopi_E]

Hi Arthur_Fong,

Thanks for the reply,

it's working as i expected, thank you

[Anil_Babu_Samineni · Accepted solution]

@Gopi_E Perhaps this

Sum({$<Month = {"$(='>=1<='& max({<MonthNum, YearMonth>} MonthNum))"}, Year = {"$(='>=2011<='& max({<MonthNum, YearMonth>} Year))"}, YearMonth= ,MonthNum=>}Sales)