Get 80% from column

[ninjoan]

Hi guys I am new to Power Bi I have a question how can I get 80% of a column that has the value ANSWERED.

Example I have a table with the following columns

DURATION = this column has numeric fields in seconds.
DISPOSITION = this column has ANSWERED OR NOT ANSWERED text fields.

I made a Column that takes the data from the DURATION column and looks for and puts the number 1 to the cells that have a duration of less than 20 seconds.

wPassOrFail = IF('Cola'[duration] < 20, 1, 0)

What I would like to do is to take 80% of the data from the Column named DISPOSITION with the value ANSWERED

[Ashish_Mathur]

Hi,

Share some data (in a format that can be pasted in an MS Excel file) and show the expected result.

[ninjoan]

Here is sample 

DISPOSITION	DURATION	wPassOrFail
ANSWERED	15	1
ANSWERED	30	0
ANSWERED	5	1
NOT ANSWERED	12	1
ANSWERED	32	0
NOT ANSWERED	20	1
ANSWERED	18	1

[Ashish_Mathur]

You have not shown the expected result.

[kaylastarr]

Hello, I am not sure I understand your question. Are you looking to take 80% of random rows from the Disposition column? Are you looking to take the top 80% of the column based on a factor?

[ninjoan]

HI im looking to take 80% of random rows from the DISPOSITION column with the value ANSWERED