% calculation

[tmarain]

I have data in table visuals below

Town               Month       Target                Sales 

A                     Jan-23       2M                    1.5M

A                     Feb-23       3M                    2.2M

A                     Mar-23      3.5M                  3M

I want to add a column with calculating % achievement of sales against the target.

Anyone can help

[DOLEARY85]

Hi,

you could just use a calculate sum measure:

Measure = CALCULATE(SUM('Table'[Sales]))/CALCULATE(SUM('Tablw)'[ Target]))

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍