Take percent of column total based upon 1 of the 2 values in the column

[jaguinaga]

Hello I am trying to determine what percent of my column (b) contains "y" and what percent contains nothing. How can I create this?

Sample	yes or blank
apple	y
orange
apple	y
apple	y
cake
grape

 

[Eric W]

Redacted. Sorry, I misread the forum.

 

[jaguinaga]

Hello I am trying to determine what percent of my column (b) contains "y" and what percent contains nothing. How can I create this?

Sample	yes or blank
apple	y
orange
apple	y
apple	y
cake
grape

End result I am look for would be the 50% number on a card

 

[snjpverma]

Like this?

Book1
	A	B	C
1	Sample	yes or blank
2	apple	y	50%
3	orange
4	apple	y
5	apple	y
6	cake
7	grape
Sheet1

Cell Formulas
Range	Formula
C2	C2	=COUNTA(B2:B7)/COUNTA(A2:A7)

 

[jaguinaga]

Like this?

Book1
	A	B	C
1	Sample	yes or blank
2	apple	y	50%
3	orange
4	apple	y
5	apple	y
6	cake
7	grape
Sheet1

Cell Formulas
Range	Formula
C2	C2	=COUNTA(B2:B7)/COUNTA(A2:A7)

Not really, i need to create a measure in powerbi to achieve that number

 

[FormR]

Hi, something like

=CALCULATE(COUNTA(Table1[Sample]),Table1[yes or blank]="Y")/COUNTA(Table1[Sample])