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???
thnx
Dave
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???
thnx
Dave