Calc. Percentage with conditions

[sdhn]

Hi All,

I have a table with some columns.

Here is a sample data:

Col 1	Vulnerable	F	Col 4
CA	NO	NOT APPLICABLE	USA
NY	YES	PENDING	USA
WA	NO	PENDING	USA
GA	NO	NOT APPLICABLE	USA
DC	YES	SCHEDULED	USA
AZ	NO	PATCHED	USA
London	Not Assessed	NOT APPLICABLE	UK
Paris	Blank	NOT APPLICABLE	FRA

I need to calculate as:

1. Percentage Vulnerable "YES" from Column Vulnerable
2. Percentage “PENDING” from column F
3. Percentage “SCHEDULED” from column F
4. Percentage “PATCHED or WORKAROUND” from Column F
5. Percentage “NOT Applicable” from column F

6. % Assessed -- This would be anything  that was labeled “blank” or “Not Assessed”.  from Column Vulnerable

Help will be appreciated 

[sdhn]

Many Thanks , Superb 

[amitchandak · Accepted solution]

@sdhn , Try measures like

divide(countrows(filter(Table, Table[Vulnerable] ="Yes")), countrows(Table))

divide(countrows(filter(Table, Table[F] ="PENDING")), countrows(Table))

divide(countrows(filter(Table, Table[F] ="SCHEDULED")), countrows(Table))

divide(countrows(filter(Table, Table[F] in{"PATCHED","WORKAROUND"})), countrows(Table))

divide(countrows(filter(Table, Table[Vulnerable] ="Vulnerable" || isblank(Table[Vulnerable]) )), countrows(Table))

or

divide(countrows(filter(Table, Table[Vulnerable] ="Yes")), countrows(allselected(Table)))

divide(countrows(filter(Table, Table[F] ="PENDING")), countrows(allselected(Table)))

divide(countrows(filter(Table, Table[F] ="SCHEDULED")), countrows(allselected(Table)))

divide(countrows(filter(Table, Table[F] in{"PATCHED","WORKAROUND"})), countrows(allselected(Table)))

divide(countrows(filter(Table, Table[Vulnerable] ="Vulnerable" || isblank(Table[Vulnerable]) )), countrows(allselected(Table)))