Filter on first column, then subtract the filtered values

[Anonymous]

My first column contains is "Yes/No" containing "Yes/No" values.

My second column is Dollars (this is a measure.)   

I would like to create a measure that represents: Yes Dollars - No Dollars

But I'm getting kludgey and chasing my tail with my filter then subtract. Any boost on how to achieve this elegantly? 

Much thanks! 

[Anonymous]

Bah, re-presenting to improve clarity:

My first value is a column that contains "Yes/No" values.

My second value is a measure of a weighted average of Amount.    

I would like to create a measure that represents Yes Amount - No Amount = Yes/No Amount Difference.

[mahoneypat]

Please share example data and desired output so a specific expression can be suggested.

Regards,

Pat

[Anonymous]

[wdx223_Daniel]

=calculate(sum(table[amount],table[yes/no]="yes")-calculate(sum(table[amount],table[yes/no]="no")