Forum Discussion
Yrstruly2021
Helper V
Helper VDistinct 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.google.com/file/d/1iI5CmvZMKetaVV7Ugwc9pBXqQqFIuAxu/view?usp=sharing
2 Replies
vikrambasriyarHelper I
Approved = CALCULATE( DISTINCTCOUNT(ServiceRequest_3[activitypoint]), ServiceRequest_3[IsApproved]=1)
v-yanjiang-msftCommunity Support
Hi Yrstruly2021 ,
Has vikrambasriyar solved your problem? If yes, please consider accept it as the solution to help the other members find it more quickly. If not, could you please explain more about your expected outcome?
Best Regards,
Community Support Team _ kalyj