topic Re: Match a column using other column ranked and filtered previously in DAX Commands and Tips

Match a column using other column ranked and filtered previously

Anonymous — Sat, 11 Jan 2020 15:07:31 GMT

I want to know how I match the rows from one column that I calculated in my matrix.

There are calculations and there will be a ranked in the first column, but i can´t match the second column

Re: Match a column using other column ranked and filtered previously

JarroVGIT — Sat, 11 Jan 2020 16:47:02 GMT

I am having a hard time understanding what your desired output is and what you are trying to achieve. Could you please ellaborate a bit?

Kind regards

Djerro123

-------------------------------

If this answered your question, please mark it as the Solution. This also helps others to find what they are looking for.

Keep those thumbs up coming! 🙂

Re: Match a column using other column ranked and filtered previously

Anonymous — Tue, 14 Jan 2020 18:48:45 GMT

I have the solution.

Thanks to god. Thanks everyone. I found the answer. Im happy to solve this problem, It take me a lot of time.

Thanks

Re: Match a column using other column ranked and filtered previously

Anonymous — Sat, 11 Jan 2020 23:18:20 GMT

Any idea? Someone to help me. please

Re: Match a column using other column ranked and filtered previously

Anonymous — Sun, 12 Jan 2020 23:51:21 GMT

The problem here is how to solve the way about how to do a "top n and other for two rows in the same table" taking by value the top of the first row.. I can do that only for one column easily with the code posted beforely.

Re: Match a column using other column ranked and filtered previously

JarroVGIT — Mon, 13 Jan 2020 04:42:54 GMT

Hi,.
I am sorry but I really don't understand what your dax is supposed to be doing, nor what the measures that it is referencing are doing. Maybe you could explain what your use case is, what your datamodel looks like and how you expected your dax to work? I also don't understand what it is representing, what do the columns mean?

Re: Match a column using other column ranked and filtered previously

Anonymous — Mon, 13 Jan 2020 15:37:59 GMT

Clear as the water djerro123.

Let the others answer my dude please

Re: Match a column using other column ranked and filtered previously

Anonymous — Mon, 13 Jan 2020 17:48:22 GMT

This is an example where both columns match with the sames number of records.

The problem here is when I change to top 6, there no match. because the top 6 from one column and the other is different.

As you know the top 21 always goin to be fine because there are 21 records in total for D_FAMILIA, but there are cases when the "Top Ventas & Other 1" and "Top kgs 6 Sem a dias Iguales" doesn´t match.Top6,Top7,Top8,Top9,Top10,Top11,Top12,Top13,Top14 also doesn´t match.

Top15 match perfectly.