Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
47 | |
26 | |
19 | |
14 | |
10 |
User | Count |
---|---|
58 | |
50 | |
44 | |
19 | |
18 |