Forum Discussion

Yrstruly2021's avatar
Yrstruly2021
Icon for Helper V rankHelper V
4 years ago

Distinct Selection on two columns

Please assist? Here is my dax to get the distinct value what i want is:  Measure = DISTINCTCOUNT(Activitypoint) I  want to see the Approved for this distinct calculation? https://drive.goog...
DAX
distinctcount
Help appreciated
vikrambasriyar's avatar
vikrambasriyar
Icon for Helper I rankHelper I
4 years ago
Approved = CALCULATE(
    DISTINCTCOUNT(ServiceRequest_3[activitypoint]),
    ServiceRequest_3[IsApproved]=1)