Help needed - separate value based on calculation

[kdrees21]

I have a rebate amount that I need to separate into 2 different categories. The rebate flows into one line item but I can split the rebate by the total costs for Category A and Category B. 

Example:

Category A Cost = $10,000

Category B Cost = $5,000

Rebate A & B = $2,500

I would calculate the Rebate for Category A by: $2,500 * (Category A Cost/Total Cost) 

Then Category B would be: $2,500 * (Category B Cost/Total Cost)

My question is how can I split the Rebate into 2 different lines:

Rebate A

Rebate B

Any suggestions? I'd like to be able to filter by category and show the rebate amount by category.

[v-xulin-mstf · Accepted solution]

Hi, @kdrees21 

1.Depend on your need, I create a table as below.

2.Use measure as:

Rebate =

VAR a =

    SUM ( Table1[Cost] )

VAR b =

    CALCULATE ( SUM ( 'Table1'[Cost] ), ALL ( 'Table1' ) )

RETURN

    DIVIDE ( a, b, 0 ) * 2500

3.Drag the columns and the measure into a table.

Here is the demo, please try it: Help needed - separate value based on calculation

Best Regards,

Link Chen

[amitchandak]

@kdrees21 , Looking at this data structure is not clear.

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.