Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Solved! Go to Solution.
ok
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.
Clear as the water djerro123.
Let the others answer my dude please
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.
Proud to be a Super User!
Any idea? Someone to help me. please
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! 🙂
Proud to be a Super User!
ok
User | Count |
---|---|
42 | |
26 | |
21 | |
16 | |
15 |
User | Count |
---|---|
54 | |
35 | |
18 | |
17 | |
15 |