Distinct count for completed requests & completed requests <> failure or error status

Hi Mous007 

it is always a good idea to provide some sample data, or sample file, when you post a question. You will get a more accurate answer, and usually users of this forum is quicker at replying posts with sample data.

You can try something like this:

Number of requests with Complete status without failures =
VAR _allComplete =
    CALCULATETABLE (
        VALUES ( 'Full History Table'[TRACKING_NUMBER] ),
        FILTER ( 'Full History Table', 'Full History Table'[STATUS] = "Complete" )
    )
VAR _withFailures =
    CALCULATETABLE (
        VALUES ( 'Full History Table'[TRACKING_NUMBER] ),
        FILTER ( 'Full History Table', NOT ( ISBLANK ( Failure ) ) )
    )
VAR _withoutFailures =
    EXCEPT ( _allComplete, _withFailures )
RETURN
    COUNTROWS ( _withoutFailures )

You will probably have to change this statement, since I don't know how a failure is described:

CALCULATETABLE (
        VALUES ( 'Full History Table'[TRACKING_NUMBER] ),
        FILTER ( 'Full History Table', NOT ( ISBLANK ( Failure ) ) )
    )

Cheers,
Sturla

If this post helps, then please consider Accepting it as the solution. Kudos are nice too.