Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Combing two measures

Hi Community.
I need to combine these two measure to work as one measure. Unique owners where reviewed = yes

ReviewedMeasure = COUNTROWS(FILTER(ProductionData, [Reviewed] = "Yes")) 
UniqueUsers = COUNTROWS(DISTINCT(ProductionData[Owner Email] ))

 Can you please help me combine them?
Thanks.
CT

Need Help

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hello Anonymous ,

    This should be achievable using the CALCULATE function:

    UniqueReviewedUsers =
CALCULATE (
    DISTINCTCOUNT ( ProductionData[Owner Email] );
    ProductionData[Reviewed] = "Yes"
)
  • dax's avatar
    dax
    Community Support
    6 years ago

    Hi CollabTechie ,

    Could you please tell us if your question has been resolved. If so, in order to close the thread, please kindly mark helpful replies as answers. By doing so, it will benefit all community members who are having this similar issue. Your contribution is highly appreciated.

    Best Regards,
    Zoe Zhi

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.