Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

DAX - Quintile calculation / Ranking

Hi there!   I am trying to build a DAX so that it groups salesmen into 5 groups (Quintiles) for each year based on the sales amount column.    Here is the sample data set. Name Region Sales...
Need Help
  • v-gizhi-msft's avatar
    v-gizhi-msft
    6 years ago

    Hi,

     

    According to your description, i define a group policy and create a calculated column:

    Group =
SWITCH (
    TRUE,
    'Table'[Sales] > 20000000, "Group1",
    'Table'[Sales] > 15000000
        && 'Table'[Sales] <= 20000000, "Group2",
    'Table'[Sales] > 10000000
        && 'Table'[Sales] <= 15000000, "Group3",
    'Table'[Sales] > 5000000
        && 'Table'[Sales] <= 10000000, "Group4",
    'Table'[Sales] <= 5000000, "Group5"
)

    Choose this column as a sclier, when select one, the result shows salesmen name for each year based on sales amount:

    Hope this helps.

     

    Best Regards,

    Giotto Zhi