Forum Discussion
Minakshi
Resolver I
Resolver ItopN DAX issue
Hello All, I have input as shown in the following table. My expection is expected column in the table but getting is the final outcome. getting = CALCULATE( SUMX(TOPN(2, table1, table1[score]),tabl...
Greg_Deckler
Community Champion
Community ChampionMinakshi - Yeah, TOPN and RANKX are going to be problematic in this regard because of how they handle duplicates. I had to jump through some hoops like this when I developed TRIMMEAN. Check that out and see if the technique used there helps. It's essentially a "while" loop.
https://community.powerbi.com/t5/Quick-Measures-Gallery/TRIMMEAN/m-p/1074075#M504