Need to show total value on row if greater than x

[CJANE]

Need help creating a measure so I can show total sum of account where individual holdings exceed X.  In the example below I need to calculate % over 12%.  I have the underlying data for Account, Secuirty, % of Account.

Account	Security	% of Account	% over 12%
1	a	5	58
1	b	10	58
1	c	10	58
1	d	8	58
1	e	23	58
1	f	35	58
1	g	10	58
2	h	35	64
2	i	15	64
2	j	14	64
2	k	12	64
2	l	12	64
2	m	12	64
3	n	30	100
3	o	20	100
3	p	20	100
3	q	20	100
3	r	20	100

[parry2k · Accepted solution]

@CJANE "% of Account" is this a column in your table or it is a measure? 

[CJANE · Accepted solution]

Thank you this was very helpful.

[parry2k]

@CJANE you can add a new calculated column like this:

Column = CALCULATE  ( SUM ( TableX[% of Account] ), FILTER (  ALLEXCEPT ( TableX, TableX[Account] ),  TableX[% of Account] > 12 ) )

[CJANE]

% of Account is a column in the table

[parry2k · Accepted solution]

@CJANE "% of Account" is this a column in your table or it is a measure?