Calculate the Sales/Target

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)

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

Anonymous , Try a measure like

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

The data type should be decimal/numeric