Filter values from different fields into a new column or measure

[alexcatala]

Hi,

I am working in a 9 box performance and I would like to produce a box where it filters that contain values between 2 of the filters. Ex. Below  and little/no

candidate	store	below	achieve	exceeds	little/no	some()	high()
Anne	709	X			X
Kevin	709		X		X

I would like to add an extra field where displays the names of those who are marked in the fields below and little/no.

Any suggestion?

thanks for your help

[amitchandak]

@alexcatala ,The information you have provided is not making the problem clear to me. Can you please explain with an example.
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
Appreciate your Kudos.

[alexcatala]

@amitchandak 

there are 2 extra columns, (employee name) and (Store) 

I would like to create a new column where it looks at column( below) and little/no and displays only the names of the employees who are marked in both of these columns like the last of the image attached.

Thanks

[alexcatala]

@amitchandak 

Any suggestion for this issue?

[v-kelly-msft]

Hi  @alexcatala ,

Go to power query>select all the filters>unpivot the columns;

Then create 2 measures as below:

Measure = IF(CALCULATE(DISTINCTCOUNT('Table'[Attribute]),FILTER(ALL('Table'),'Table'[Value]<>BLANK()&&'Table'[candidate]=MAX('Table'[candidate])))=2,1,0)

Measure 2 = IF(CALCULATE(MAX('Table'[Value]),FILTER(ALL('Table'),'Table'[Attribute]="little/no"&&'Table'[candidate]=MAX('Table'[candidate])))<>BLANK(),MAX('Table'[candidate]),BLANK())

And you will see:

For the related .pbix file,pls see attached.

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

[alexcatala]

@v-kelly-msft 

Hi Kelly,

My concern was to look at 2 columns, not only 1. As you selected the (little/no) but also is needed with (below), similar than vlookup in excel. 

What I am trying to obtain is if both have value, then appear in a new column/ measure.

I am trying to create a succession plan.

As you can see I have 6 columns ( Below, Achieves, Exceed) and (Little/no, Some ( 1 up), High ( 1 + up) 

I want to create a measure to could create in each a combination between the Horizontal values ( Below, Achieves, Exceed) with Vertical ( Little/no, Some ( 1 up), High ( 1 + up).

Only if they have a value. Ex if they have a value in Below and Value in Little/no, then automatically appear inbox on the bottom left.  Having multiple choices to fill all these boxes and do not have to make this manually.

Any suggestion?

Thanks for your help

[v-kelly-msft]

Hi @alexcatala ,

After reflection,I really have no idea on how to get a result,would you pls clearly advise me an expected output?

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!