I am trying to write a formula to bring back the distinct sku count for a specific year. If I just do a count(distinct I get counts for anything that is in the data set even if it is years old. I am trying to compare one year's sku count to another. I found that count(distinct if ( (ZINVSLS)>1,Material)) returns the correct value if I select a certain year but when I try count(distinct if (sum({<Year={'2020'}>}(ZINVSLS)>1), Material)) I get an error. I want my expression to calculate sku count for a specific year.
