Calculate percentage of total COUNT of column based on condition

[JayKarim]

Hi All, 

I'm having trouble creating a measure and hoping you can help find a solution

I have 1 column called  "Referred Claim to Underwriters"

There are 2 values in the column, "N" and "Y"

I want to show in a Card visual to show what % of the total count is "N" 

What formula should i use in my measure?

Many thanks in Advance

Jay  

[Jihwan_Kim · Accepted solution]

Hi,

Plesae try something like below.

Ratio measure: =
DIVIDE (
    CALCULATE ( COUNTROWS ( TableName ), TableName[ColumnName] = "N" ),
    COUNTROWS ( TableName )
)