Hi guys. First of all thanks for your at

Written by DaveCRT.

Hi guys. First of all thanks for your attention. Easy question I'm using this syntax in excel power pivot table =DISTINCT(ALL(Table2[sedi]) to get as result all the unique values that the field "sedi" displays, despite filters applied in the corresponding pivot table But i got as result "The DISTINCT function expects a column reference expression for argument '1', but a table expression was used." Any tips???