Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Divide correctly when rows are aggregated?

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 🙂

 
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

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

2 Replies

  • davehus's avatar
    davehus
    Memorable Member
    3 years ago

    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's avatar
      Anonymous
      Not applicable
      3 years ago

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