Forum Discussion

jlam's avatar
jlam
Frequent Visitor
7 years ago
Solved

Commission Report

Hello,   I am trying to build a commission report in Power BI. In my Excel report right now, I am using a SUMIF formula to calculate the Gross Sales based on the Margin % earned on the sale. So for...
Need Help
AlB's avatar
AlB
Community Champion
7 years ago

Hi jlam

It'd be easier of you showed a sample of your data model. 

I think you could use a measure:

 

Measure =
YourSetCommissionPercentage * 
    CALCULATE (
        SUM ( Table1[TotalPriceOfSale] ),
        Table1[Margin%] >= 0,
        Table1[Margin%] <= 20
    )

 

jlam's avatar
jlam
Frequent Visitor
7 years ago

Hello,

 

I am trying to replicate the following into Power BI. 

 

 

 

If I use your suggested measure to calculate each Margin Range, would I create a column to calculate the Part Sales using an IF formula?

 

Thank you,

Jessica