Calculate percentage between multiple values in the same colum

[AMBP73]

Hello,

I am trying calculate the percentage between values in the same column, but using more than one value as the difference. For example count of yes and potential (total %) v not reviewed and no. I would like to display % of yes and potential (together) vs total count in a card. I.e. yes/potential is % of total.

Thanks in advance for any assistance 🙂

[Mahesh0016 · Accepted solution]

@AMBP73  I hope this helps you. if no please share your Expected Result in the table for a better understanding. Thank You.

> Get total count of review column

Count Review =

CALCULATE (

    COUNT ( 'Table Review'[Review] ),

    ALLSELECTED ( 'Table Review'[Review] )

)

#######################

Yes/Potentail Count =

CALCULATE (

    COUNT ( 'Table Review'[Review] ),

    'Table Review'[Review] IN { "Yes","Potential" }

)

#################################

Yes/Potential % =

DIVIDE ( [Yes/Potentail Count], [Count Review], 0 )

[AMBP73]

Thankyou so much Mahesh0016, this worked perfectly 😊👍

[Mahesh0016]

it's my pleasure🤗.

[AMBP73]

Hello Mahesh0016. 

Sorry to be painful, one more this please. When I put this measure in a card visual and filter in a slicer by the same field, it is returning some strange results I.e. 340% for 'not reviewed', and 1020% for 'no'. I would have expected 0%?  When filtering by those values?