yes/no percentage

[Anonymous]

Hi, 

i want to work out the percentage for yes for every country 

eg if sweden has 20 records consisting of Yes,TBC, No, i want to work out the percentage of yes out of those 20 records and same for every other country.

can you please advise

i would appreciate any advice

[v-janeyg-msft · Accepted solution]

Hi, @Anonymous 

According to your description,I think you can create a measure.

Like this:

Measure =
VAR a =
    COUNTX (
        FILTER (
            ALL ( 'Table' ),
            [value] = "yes"
                && [country] = SELECTEDVALUE ( 'Table'[country] )
        ),
        [value]
    )
VAR b =
    COUNTX (
        FILTER ( ALL ( 'Table' ), [country] = SELECTEDVALUE ( 'Table'[country] ) ),
        [value]
    )
RETURN
    DIVIDE ( a, b )

If it doesn’t solve your problem, please feel free to ask me.

Best Regards

Janey Guo

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

[VijayP]

@Anonymous 
Create a Measure 

YesCount = Calculate(count(termination issued),filter(all(tablename),terimination issued ="Yes"))
Then  create another measure , divide (yescount,Count(termination issued),0) and add this to the visual to show Yes % separately! Let me know if any further help requried!