Forum Discussion
Distinct Count rows based on Dimension Attribute Order Priority
Dear, We have a particular business case where we have multiple documents and multiple status per document. We would like to count the distinct number of documents per status but avoiding double...
Anonymous
Because the filter expression is max([status id], if you want filter based on the priority. Try change the underlined part to min([Priority]), keeps others the same.
Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.