Percentage completed of total quantity

[abujouz86]

Hello,

I am trying to show percentage of total quantity completed for production orders in a given week. As part of the table I have two columns (1) total quantity on the production order (2) total completed on the production order. The table includes a date column so I can filter by relative date on the visual. 

I'm not sure how to write the measure in pbi. I thought the dax measure would be: = DIVIDE(SUM(qtycompleted),SUM(qty)) * 100

But the answer I get is slightly different (a few percent) than when I export the table to excel and divide qtycompleted / qty * 100.

Am I writing the dax incorrectly?

[Anonymous]

It's not possible to answer the question. Please post some data.

[abujouz86]

Sorry - without the * 100 on the pbi dax, formatting the measure as a percentage