Forum Discussion

tmarain's avatar
tmarain
New Member
3 years ago

% calculation

I have data in table visuals below Town               Month       Target                Sales  A                     Jan-23       2M                    1.5M A                     Feb-23       3M  ...
Tips and Tricks
DOLEARY85's avatar
DOLEARY85
Resident Rockstar
3 years ago

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 👍