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
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.
This works, but when I filter on other things in the report, it is multiplying all cost still instead of what is filtered. Anyway to get around this? For instance. If had the same table as above but added in one more column for filtering. Example below.
Company Channel Cost A Direct $ 100.00 B Disty $ 200.00 C Disty $ 100.00 A Direct $ 500.00 A Disty $ 600.00