Forum Discussion

tvw83's avatar
tvw83
New Member
5 years ago

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...
Need Help
Anonymous's avatar
Anonymous
Not applicable
5 years ago

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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi,

    That's not fully correct.What I need is to get the minimum priority per documentId and as such I know the corresponding Status(Id).

    I tried to implement it :

     

    But the result is not correct:

    I become StatusID 3 = count of 4 (all documents)

    While the count result should be :

    StatusID 1 = 1 (DocumentId 2)

    StatusID 2 = 1 (DocumentId 1)

    StatusID 3 = 3 (DocumentId 3, 4,5)

    StatusId 4 = 0

     

    What is wrong with my measure ?