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
A few things to consider when choosing a calculated column vs measure.
https://www.sqlbi.com/articles/calculated-columns-and-measures-in-dax/#:~:text=The%20difference%20is%20the%20context,the%20table%20it%20belongs%20to.
Try the measure I posted earlier to see if you get your desired result.
Hello Syk I tried your solution as well, and though it works in isolated instances. It also like the column doesn't work when I use certain filters. Any ideas how I get it to apply to when I filter?
Depends 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