Forum Discussion
Need Help in calculating distinct count using multiple conditions
Hi, Need help in calculating distinct count of App where tickets status is approved but those should include only tickets where you have one Approved status. so for example if app A is have ...
Hi mandeeps19 ,
I suggest you to try code as below to create a measure. I think the result should be 0.
Distinct Count APP only in Approved Status =
CALCULATE ( DISTINCTCOUNT ( 'Table'[APP] ) )
- CALCULATE (
DISTINCTCOUNT ( 'Table'[APP] ),
FILTER (
'Table',
NOT ( 'Table'[Status] IN { "Approved With Exceptions", "Conditionally Approved" } )
)
)Result is as below.
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
The result should be 4 as you can see A,C,D & E doesnt have the approved status