Forum Discussion
shabeercp659
1 year agoRegular Visitor
Detail Table Won't Filter Automatically for Top N, Even When Grand Total is Correct
https://drive.google.com/drive/folders/1B4J-i9eTyTEmBX-c_AZd1OlyzR9gby4W Hello Power BI Community, I am facing a very persistent issue with a Top N report that seems to defy the normal behavior...
- 1 year ago
You need to remove the filters from the ticket id column,
Top Traveler Rank = VAR SelectedN = [Top N Selection Value] VAR TravelerRank = RANKX( ALL(Travelers), CALCULATE([Total Amount], REMOVEFILTERS( Data[Ticket Number] )), , DESC, DENSE ) RETURN TravelerRankYou'd need to do the same thing in the Is Top Traveller measure, and then add [Is Top Traveller] to the detail table as a filter, to only show when the value is 1.
v-lgarikapat
Community Support
1 year agoHi shabeercp659 ,
Thanks for reaching out to the Microsoft fabric community forum.
johnt75 ,
Thanks for your prompt response
I wanted to check if you had the opportunity to review the information provided by johnt75 , Please feel free to contact us if you have any further questions. If my response has addressed your query, please "Accept as Solution" so other members can easily find it.
Best Regards,
Lakshmi Narayana