Forum Discussion
Row 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...
Hi, 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])
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?