Forum Discussion
Get 80% from column
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
5 Replies
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?
HI im looking to take 80% of random rows from the DISPOSITION column with the value ANSWERED
Hi,
Share some data (in a format that can be pasted in an MS Excel file) and show the expected result.
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 You have not shown the expected result.
