topic Re: Calculate the Sales/Target in DAX Commands and Tips

Calculate the Sales/Target

Anonymous — Tue, 04 Aug 2020 04:12:18 GMT

How To Calculate the Sales/Target

% column incorrect, actual % is done?

Kinldy Help

Fowmy — Tue, 04 Aug 2020 04:16:21 GMT

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 🙂

amitchandak — Tue, 04 Aug 2020 04:52:23 GMT

Anonymous , Try a measure like

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

The data type should be decimal/numeric

Anonymous — Tue, 04 Aug 2020 05:06:44 GMT

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)