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.
Hello everyone,
Why can't I initially sort the "KPI" column by the "ORDER" column, because of the repeated data?
But when I remove duplicates, I manage to sort.
And when I exclude the removal of duplicates, does the "KPI" column remain ordered by the "ORDER" column even with the duplicates?
Hi @Anonymous
if you want to sort KPI 1 by column Order which order should be taken 1 or 3? It's the same with KPI 2: 2 or 4?
The sort order must be distinct!
With kind regards from the town where the legend of the 'Pied Piper of Hamelin' is at home
FrankAT (Proud to be a Datanaut)
Hi @FrankAT
The classification in this last image is correct, there are duplicates for the KPI, but they are different calculations.
My question is why the KPI column does not sort on the first attempt, but only when removing as duplicates and subsequently excluding a duplicate removal step with it left in order.
It looks like an interesting finding. I will probably use it as a trick in some sorting scenarios. Thanks. @Anonymous
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 |
---|---|
112 | |
100 | |
77 | |
74 | |
49 |
User | Count |
---|---|
146 | |
108 | |
106 | |
90 | |
62 |