Distinct count based on 3 criterias

Hi reddevil 

Use two separate measures. One to find the distinct count of Measure Descriptions where Actuals ≥ Target, and another to find the distinct count of all Measure Descriptions.

Measure 1 (Actuals ≥ Target):

DistinctCount_ActualsGreaterEqualTarget =
CALCULATE(
    DISTINCTCOUNT('Table'[Measure Description]),
    FILTER(
        ALL('Table'),
        'Table'[Actuals] >= 'Table'[Target]
    )
)

Measure 2 (All Measure Descriptions):

DistinctCount_MeasureDescription =
DISTINCTCOUNT('Table'[Measure Description])

Adjust the table and column names as necessary. These measures give you the distinct counts as required.

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

Appreciate your Kudos!! 

LinkedIn|Twitter|Blog |YouTube