Calculate the Sales/Target

[Anonymous]

How To Calculate the Sales/Target

% column incorrect, actual % is done?

Kinldy Help

Type	Target	Sales	%	Actual By manual
GIRLS	4.16	1.74	40%	41.88%
LADIES	81.68	63.07	74%	77.21%
LADIES GIANT	1.51	0.76	48%	50.23%

[harshnathani]

Hi @Anonymous ,

Create a Measure

 Actual by Manual  = DIVIDE('TABLE'[Sales],'TABLE'[Target])

Change the format of the measure.

Regards,
Harsh Nathani

Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)

[amitchandak]

@Anonymous , Try a measure like

divide(sum(Table[Sales]),sum(Table[Target]))

The data type should be decimal/numeric

[Fowmy]

@Anonymous 

Try 

=DIVIDE(TABLE[Sales],TABLE[Target])

Then format as %.

________________________

Did I answer your question? Mark this post as a solution, this will help others!.

Click on the Thumbs-Up icon on the right if you like this reply 🙂

YouTube, LinkedIn