Skip to content

My Collection

Of Useful Things

  • custom
  • Cumulative Measures
  • Time Intelligence
  • Averaging Measures
  • Ranking Measures
  • Time Comparison
  • Percent of Totals
  • Core Measures
  • Moving Averages

Top Region Sales

December 16, 2022December 16, 2022 ~ Dax

Top 5 Region Sales =

Calculate([Total Sales],

TopN (5, Regions, [Total Sales]))

Remaining Region Sales

Remaining Region Sales =

Calculate ([Total Sales],

Filter(Regions,

RANKX(ALL (Regions), [Total Sales]) > 5 ))

Like Loading...
Posted in Ranking Measures
Unknown's avatar

Published by Dax

View all posts by Dax

Post navigation

‹ PreviousSales LY
Next ›CountROWS
Blog at WordPress.com.
  • Subscribe Subscribed
    My Collection

    Have a WordPress.com account? Log in now.

  • My Collection
    Copy shortlinkView post in Reader
    Manage subscriptionsSign upLog in
    Report this content
    Collapse this bar
%d