How to calculate a loss ratio relativity? Divide ratio for a specific year by the overall ratio

[Anonymous]

In PowerBI, I was able to just create the Loss Ratio measure for my matrix visual as it was just doing division of Ult Loss/Ult Premium with the simple quick measure function:

Ult Loss Ratio =

DIVIDE(SUM('Version4'[Ult Losses]), SUM('Version4'[Ult EP]))

This is analagous to creating a calculated field in Excel after generating the pivot table.

However, when calculating a relativity, which in this case is dividing a loss ratio for a specific year by the overall loss ratio. I wasn't sure how to do this in PowerBI:

In Excel you kinda have to brute force it with the cell locking and stuff. In PowerBI I wasn't sure how to go about it. 'Year' is not the only variable I'm slicing my data by (and creating matrix visuals for) so the measure would have to be flexible where you can just drag and drop regardless.

Can anyone help me out here? Thanks!

[jdbuchanan71 · Accepted solution]

@Anonymous 

Give this measure a try, see if it give you what you are lookin for.

Reltativity =
VAR _Overall = CALCULATE ( [Ult Loss Ratio], ALL ( 'Version4' ) )
RETURN
DIVIDE ( [Ult Loss Ratio], _Overall )