Calculated Columm with same number

[12Bowers12]

Good afternoon, everyone,

In the following table, Column BI Limit is a calcuated column. 

In this calculated column, I need to fill in the Coverage BI Limit information within the same policy number. 

Appreciate your help.

Dennis

Policy	Coverage	Limit	BI Limit
456	BI	50	50
456	PD	60	50
456	PIP	70	50
321	BI	40	40
321	PIP	30	40

[HotChilli]

Column = VAR _policy = 'Table'[Policy]
RETURN
   CALCULATE(MAX('Table'[Limit]),
   FILTER('Table', 
   'Table'[Policy] = _policy &&
   'Table'[Coverage] = "BI"))

[12Bowers12 · Accepted solution]

Thank you so much, it works perfectly. A good day. Dennis