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...
Need Help
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"
)