Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Calculating Store Comission Fees

Hello.    Here's what i got:   Seller | Store | Revenue  1             2         1.200 2             2          800 3             1          300 4             1          500   I want to cre...
  • Jihwan_Kim's avatar
    Jihwan_Kim
    5 years ago

    Hi, Anonymous 

     

    Please try the below measure.

     

    Comission store level =
    VAR
    totalrevenue = CALCULATE( SUM('Table'[Revenue]), ALLEXCEPT('Table', 'Table'[Store]))
    RETURN
    IF( totalrevenue >= 1000, 0.05, 0.025)
     

    Hi, My name is Jihwan Kim.

    If this post helps, then please consider accept it as the solution to help other members find it faster.

Jihwan_Kim's avatar
Jihwan_Kim
Super User
5 years ago

Hi, Anonymous 

 

Please try the below measure.

 

Comission store level =
VAR
totalrevenue = CALCULATE( SUM('Table'[Revenue]), ALLEXCEPT('Table', 'Table'[Store]))
RETURN
IF( totalrevenue >= 1000, 0.05, 0.025)
 

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster.

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Thanks Jihwan, it worked just as i needed.

     

    I appreciate your help.