https://community.fabric.microsoft.com/t5/s/yrjkf47658/tracker Kpavanteja91 Tracker Sun, 20 Sep 2026 21:55:07 GMT 2026-09-20T21:55:07Z https://community.fabric.microsoft.com/t5/Desktop/Summarize-and-Rank-by-multiple-columns-and-rows/m-p/630087#M301166 <P>Rank = RANKX(CROSSJOIN(ALLSELECTED(Table[Client Name]),ALLSELECTED(Table[Revenue Stream])),CALCULATE(SUM(Total Revenue)))</P> Fri, 22 Feb 2019 23:00:44 GMT https://community.fabric.microsoft.com/t5/Desktop/Summarize-and-Rank-by-multiple-columns-and-rows/m-p/630087#M301166 Kpavanteja91 2019-02-22T23:00:44Z