% calculation

Question

I have data in table visuals belowTown&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Month&nbsp; &nbsp; &nbsp; &nbsp;Target&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Sales&nbsp;A&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Jan-23&nbsp; &nbsp; &nbsp; &nbsp;2M&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1.5MA&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Feb-23&nbsp; &nbsp; &nbsp; &nbsp;3M&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2.2MA&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Mar-23&nbsp; &nbsp; &nbsp; 3.5M&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 3MI want to add a column with calculating % achievement of sales against the target.Anyone can help

doleary85 · Answer

Hi,&nbsp;you could just use a calculate sum measure:&nbsp;Measure = CALCULATE(SUM('Table'[Sales]))/CALCULATE(SUM('Tablw)'[&nbsp;Target]))&nbsp;If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Forum Discussion

% calculation

1 Reply

Related content

MoM calculation

Calculation Help

Calculate Tooltips

Hour Calculation

Calculating with Filters