Forum Discussion
Match a column using other column ranked and filtered previously
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
7 Replies
- JarroVGIT
Resident Rockstar
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! 🙂
- JarroVGITHi,.
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?
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.
