Divide correctly when rows are aggregated?

[Anonymous]

Hi!

If I have a number of rows then the aggrgated total is not what I want.

In the example below I need 100% in total not 200%

(My formula is simply 

Calculate(Divide(sum('Delivery Precision'[Order deliveries on time]);sum('Delivery Precision'[No. of Order Lines]))) I have tried without Sum and without calculate and with SUMX but I still can't get it to work.)

Grateful for help 🙂

[davehus]

Hi @Anonymous ,

You don't know calculate wrapped around the measure. Try it without it. 

Hope this helps.

Did I help you today? Please accept my solution and hit the Kudos button.

[Anonymous · Accepted solution]

The above was a column measure (I forgot to say), so as soon as I put it in as just a measure it worked!