Calculating Percentage

[Alwyn1991]

Hi all, 

Apologies if this has already been answered but im looking to work out how to calculate the % of a column.

the scenario is
100 Audits Undertaken 60 of them Passed and 40 of them have failed

i want to show  a card Visual to show that 60% passed, the column only has the text "pass" or "fail"

Thanks

Al

[Anonymous · Accepted solution]

Hi

you can create a measure:

Passed =

DIVIDE (

    COUNTROWS(FILTER(Table1;Table1[Column1]="pass"));

    COUNTROWS(Table1)

)

Remember to format the measure as percentage 🙂

[parry2k · Accepted solution]

@Alwyn1991 try this

% Passed = 
DIVIDE(
CALCULATE( COUNTROWS( Table ), Table[Column] = "Passed" ),
COUNTROWS( Table )
)

[Anonymous · Accepted solution]

Hi

you can create a measure:

Passed =

DIVIDE (

    COUNTROWS(FILTER(Table1;Table1[Column1]="pass"));

    COUNTROWS(Table1)

)

Remember to format the measure as percentage 🙂