Forum Discussion

mandeeps19's avatar
mandeeps19
New Member
3 years ago

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 ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
3 years ago

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.

  • mandeeps19's avatar
    mandeeps19
    New Member
    3 years ago

    The result should be 4 as you can see A,C,D & E doesnt have the approved status