How to calculate Percentage for Successful Status for Different Categories?

[Anonymous]

I have following data: 

JobName	Status
A	Success
A	Failure
A	Internal Error
B	Success
B	Success
A	Success
A	Success
C	Failure
A	Failure
C	Success
C	Internal Error
C	Internal Error
B	Success
B	Failure
V	Success
A	Internal Error
C	Internal Error
S	Success
S	Internal Error

I want to have Count of Records with Status 'Success' for every JobName.
I do not want to calculate a separate table as it doesn't interact with the timeline slicer, rather a column.

SuccessCount =

var Job = [JobName]

var Total = CALCULATE(COUNT(combined_csv[JobName]);combined_csv[JobName] = Job)

var Success = CALCULATE(COUNT(combined_csv[JobName]);combined_csv[JobName] = Job; combined_csv[Status]="Success")

return DIVIDE(CALCULATE(COUNT(combined_csv[JobName]); combined_csv[Status]="Success");CALCULATE(COUNT(combined_csv[JobName])))

But it's giving me wrong result.
Can anybody help in this!

[v-xicai · Accepted solution]

Hi @Anonymous ,

You can create measure like DAX below.

SuccessCount =
DIVIDE (
    CALCULATE (
        COUNT ( 'combined_csv'[JobName] ),
        FILTER (
            ALLSELECTED ( 'combined_csv' ),
            'combined_csv'[JobName] = MAX ( 'combined_csv'[JobName] )
                && 'combined_csv'[Status] = "Success"
        )
    ),
    CALCULATE (
        COUNT ( 'combined_csv'[JobName] ),
        FILTER (
            'combined_csv',
            'combined_csv'[JobName] = MAX ( 'combined_csv'[JobName] )
        )
    )
)

Best Regards,

Amy

Community Support Team _ Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.