Forum Discussion

adj87's avatar
adj87
Helper I
2 years ago
Solved

Commission Measure

Hi Everyone, I need help building a commission measure. I've found a lot of references which filter the Commission Tier and then multiplies the current sales * max commission percentage, but our com...
@measure
  • some_bih's avatar
    some_bih
    2 years ago

    Hi adj87 I think one of the way is to get Commision Key (column which is not in your overview, but should be) into Sales / Fact table as calculated column on wanted level (order or what you need). Additioanal ideas could be found on link https://www.daxpatterns.com/dynamic-segmentation/ 

    Hope this help. Kudos appreciated.

some_bih's avatar
some_bih
Community Champion
2 years ago

Hi adj87 I think one of the way is to get Commision Key (column which is not in your overview, but should be) into Sales / Fact table as calculated column on wanted level (order or what you need). Additioanal ideas could be found on link https://www.daxpatterns.com/dynamic-segmentation/ 

Hope this help. Kudos appreciated.

adj87's avatar
adj87
Helper I
2 years ago

Thanks some_bih  for the response. I forgot about the use of Patterns in this instance, they will certainly help with a secondary issue I was running into.

 

I was able to add the commission structures to my sales tables. I included a few IF statements, a SUMMARIZED table to sum the commissions by ID and Week and everything is correct.

 

The main reason I had dismissed this method is it hard coded the tiers and the purpose of this project is to compare Current Tiers vs Proposed Tiers, so I will just have to find a different way to do that 🙂