measures - Dividing 2 columns to get a percentage measure

[JayKarim]

Hi, 

I have 2 measures with numeric values. My end goal goal is to get a measure which gives me a % value of one over the other.

The 2 measures are:

1. Actual Losses Recovered (£)

2. Insured Loss Reserve

formula: Actuak losses recovered / insured loss Reserve 

I'm using the following measure but this is giving me an average % which i don't want:

% of losses Recovered = DIVIDE ([Actual Losses Recovered],  [Insured Loss Recovered],0)

I want the total sum of one column divided by the total suym of the other column which gives me the exact % value on my scorecard visual

Any help will be appreciated

Many thanks,

Jay  

[Vijay_A_Verma · Accepted solution]

Use one of the following. Second one removes all filter applied to the table

% of losses Recovered = DIVIDE (SUM([Actual Losses Recovered]),  SUM([Insured Loss Recovered]),0)

% of losses Recovered1 = DIVIDE (CALCULATE(SUM([Actual Losses Recovered]),ALL('Table')),  CALCULATE(SUM([Insured Loss Recovered]),ALL('Table')),0)

[JayKarim]

It works. Thank you so much 🙂