Forum Discussion
Multiplier depending on critera
Hey there Anonymous,
What you need to do is create a DAX Calculated column. The formula should look like this:
Column Name = If('Table'[Channel] = "Disty", 'Table'[Cost] * 1.06, 'Table'[Cost])
If this is correct please think about marking it as a solution.Oh you're saying you just don't want the Direct cost? Only disty?
Disty Cost = CALCULATE ( SUM ( 'table'[cost] ), 'table'[Channel] = "Disty" ) * 1.06
Resident RockstarDepends on your relationships and the filter.. Can you give an example?
So I added the table below to show sort of what I mean. I'm only using one data source right now, so no relationships have been made. I simply will choose a Company, and it will sum up all the ones labled "Disty" not just Company A for instance.
| Company | Channel | Cost |
| A | Direct | $ 100.00 |
| B | Disty | $ 200.00 |
| C | Disty | $ 100.00 |
| A | Direct | $ 500.00 |
| A | Disty | $ 600.00 |
- Syk
You're trying to sum this up by company? A little confused by this response.
Right now this is what I'm showing by copying your example.If you set Cost to sum, you'll get
And if you want it rolled up by company, just remove the other detailsHey Syk That is correct. Trying to sum things up by each company. So if I choose Company A, I just want back the sum of the disty cost by company A. I want to be able to do that with each company I select.
- Syk
Oh you're saying you just don't want the Direct cost? Only disty?
Disty Cost = CALCULATE ( SUM ( 'table'[cost] ), 'table'[Channel] = "Disty" ) * 1.06