Calculate the name of a cell based on its value and column

[kostask]

Hi, guys.

Actually, I'm not sure if it is possible to be solved since it seems pretty sophisticated.

So I have a matrix with rows (values A, B, C..) and columns (X, Y, Z), where I apply a calculated measure which gives numerical values as below:

	X	Y	Z
A	10	8	7
B	1	4	5
C	3	4	5
D	1	9	7

Is it possible for every row to grab the highest value and give it the name of the column that it belongs to?

So the final desirable output would be:

	X	Y	Z
A	X
B			Z
C			Z
D		Y

Thanx!

Kostas

[Jihwan_Kim · Accepted solution]

Hi, @kostask 

Please check the below picture and the sample pbix file's link down below, whether it is what you are looking for.

All measures are in the sample pbix file.

https://www.dropbox.com/s/aowbs9mcj9pnijq/kostask2.pbix?dl=0 

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

Linkedin: https://www.linkedin.com/in/jihwankim1975/

[kostask]

Another great solution.

Thank you @Jihwan_Kim!

[Jihwan_Kim · Accepted solution]

Hi, @kostask 

Please check the below picture and the sample pbix file's link down below, whether it is what you are looking for.

All measures are in the sample pbix file.

https://www.dropbox.com/s/aowbs9mcj9pnijq/kostask2.pbix?dl=0 

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

Linkedin: https://www.linkedin.com/in/jihwankim1975/

[kostask]

Hi @Jihwan_Kim. It seems that I wasn't actually right at my description.

In fact, the table is virtual and is produced by other tables and a calculated measure and is not single that stands by itself.

But what actually really can help is that the result I want to retrieve follows your solution that you gave me last time.

Actually, I want to replace the biggest variance per row level at the following table, with the column name that it belongs to.

For example, at Cus001 I want to replace the biggest row var (38,57%) with Prod Catz where it belongs,

at Cus002 32,14% with Prod CatZ also, at Cus005 21,00% (which is the biggest variance) with ProdCatY etc. Is it possible?

https://www.dropbox.com/s/qvigj4ihu246qcn/kostask.pbix?dl=0 

Thanx

Kostas

[Jihwan_Kim · Accepted solution]

Hi @kostask 

I am not sure whether I understood your instruction correctly.

Please check the below picture and the link down below.

The measure is in the sample pbix file.

https://www.dropbox.com/s/qvigj4ihu246qcn/kostask.pbix?dl=0 

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

Linkedin: https://www.linkedin.com/in/jihwankim1975/