This Post Has 3 Comments

  1. Very useful post. This is equivalent to using sumproduct(–(A1>(range),A1-(range),(comm rates)) in regular excel where you would have to repeat it based on the customer (or change the formula to look up customer name and thus range).

    The steppe approach is very common when calculate commissions as well as taxes so thanks for posting the DAX because I wouldn’t have figured it out on my own!

  2. Hello,

    For the commisison2 i wrote new dax as you think that has bug?

    Commision3:=SUMX(VALUES(Dates[MonthEndDate]),[Comm2_Base]+ ( [Comm2_SalesValue] * [Comm_Rate] ))

Leave a Comment or Question