Set analysis help

[siri_v]

Hello all, I need help with this Set analysis calc. 

I need to default the table/dashboard always with the below calculation where Year is max and Product should be defaulted to "All". This is working as expected.

But when I change the product filter to a different option, it still shows the results of Product"All" category. 

I am not able to get dynamic update for Product field. Can you help with syntax for the same. 

  (Sum({$<Year={$(=Max(Year(Saledate)))},Product={"All"}>}Sales)

[GaryGiles · Accepted solution]

If you specify a field and value in set analysis, it will override any selections made in the field in a filter.

Not sure of the exact behavior you are looking for, but to default to 'All', but switch to products selected in filter if a filter is applied, you could use something like:

sum({$<Year={$(=Max(Year(Saledate)))},Product={$(=if(GetSelectedCount(Product)=0,'All',GetFieldSelections(Product)))}>}Sales)

[siri_v]

Excellent @GaryGiles ! This is exactly what I need.. Worked like a charm! Thanks a ton!