Hi All - This should be a simple answer but I’m struggling for some reason. Please find attached pbix file. I’m trying to create a measure that subtracts 10 from sales for Target Customers.
Sample.pbix (41.9 KB)
Here’s my measure:
Target$ = CALCULATE(SUM(Sales[Sales])-10, Customer[Target Customer]=“Yes”)
However when I put this measure besides my customers, it shows Sales-10 for all customers. It also repeats Yes and No for each customer.
The right answer for the Target$ should just be A, B and C show (sales -10) and other customers should not show any values. Could someone help?