Totals incorrect with measure

[bml123]

Hi,

I have data like this

Id	Amount	Flag
1	10	Yes
2	20	No
3	30	Yes
4	40	No
5	50	Yes
Total	150

Amount and Flag are measures. I want to have other columns ValueswithYES, ValueswithNO and totals like this

	Id	Amount	Flag	ValueswithYES	ValueswithNO
	1	10	Yes	10
	2	20	No		20
	3	30	Yes	30
	4	40	No		40
	5	50	Yes	50
Total		150	Yes	90	60

I have used measures like this ValueswithYES = if(Flag="Yes",[Amount]), getting the values right but the total I am getting as 150 which is incorrect. How do I achieve this?

[CNENFRNL · Accepted solution]

Values w/ YES = SUMX(VALUES(DATA[ID]),IF([Flag]="YES",[Amount]))

Values w/ NO = SUMX(VALUES(DATA[ID]),IF([Flag]="NO",[Amount]))

[bml123]

That didn't work. My Flag is also measure. 

Getting this error A function 'PLACEHOLDER' has been used in a True/False expression that is used as a table filter expression. This is not allowed.

[ChrisMendoza]

What is the measure for 'Flag'?

[ChrisMendoza]

@bml123 - try as:

ValueswithYes Measure = 
CALCULATE(
    [Amount Measure],
    TableName[Flag] = "Yes"
)

ValueswithYes Measure = 
CALCULATE(
    [Amount Measure],
    TableName[Flag] = "No"
)