Match a column using other column ranked and filtered previously

[Anonymous]

HI

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

[Anonymous]

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.

[Anonymous]

Clear as the water djerro123.

Let the others answer my dude please

[Anonymous]

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.

[JarroVGIT]

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?

[Anonymous]

Any idea? Someone to help me. please

[JarroVGIT]

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! 🙂

[Anonymous · Accepted solution]

ok

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