topic Re: Calculate the name of a cell based on its value and column in DAX Commands and Tips

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

kostask — Wed, 14 Apr 2021 06:58:07 GMT

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

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

Jihwan_Kim — Wed, 14 Apr 2021 07:24:23 GMT

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/

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

kostask — Wed, 14 Apr 2021 08:21:49 GMT

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

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

Jihwan_Kim — Wed, 14 Apr 2021 08:50:47 GMT

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/

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

kostask — Thu, 15 Apr 2021 09:01:02 GMT

Another great solution.

Thank you Jihwan_Kim!