This RANKX pattern is in thousands of Power BI reports. Here's what's actually wrong with it

Samenvatting

Sales Rank = RANKX( ALL(Products[ProductName]), CALCULATE( SUM(Sales[Amount]) ), , DESC, DENSE ) RANKX forces a full table scan for every row: Formula Engine heavy at 77% CALCULATE wrapping SUM with no filters adds unnecessary context transition If you only need Top-N, TOPN is Storage Engine optimized and significantly faster submitted by /u/Akha6e [link] [comments]