Forum Discussion
samc_26
Helper IV
Helper IVRow level filter with calculation
Hi all, I have a table with a list of costs against different people but for one person I want to give them a 50% discount, in this case I'll use Charlie as the chosen one! So I want the £200 to stay...
Create e new Measure and assign factor for selected value
Net Sales Factored =
var _Category = CALCULATE( [Net Sales] * 1.5, Category[Product Category] = "Audio")
var _SelectedCategory = SELECTEDVALUE(Category[Product Category])
return switch(true, _SelectedCategory = "Audio", _Category, [Net Sales])
samc_26Hi, thank you for your post, I've tried to use it but I'm not sure what rhe measure 'Net Sales' is in this example, is it just a sum of all sales from the charges column?
Yes, [Net Sales] is another measure that is just the sum of sales. It is to show, you create the original measure first, then you can use it another measure
Net Sales = SUM( Sales[SalesAmount])- samc_26
Hi Anonymous I've tried this but it just appears to show the original value and doesn't calulate the difference of the 50% discount for the one name?