I STILL cant get percentages to work!!!!

[tarrantmark]

Hi - I have looked through numerous forum posts and you tube videos but just cant get a % calculation to work! 

Basically I have an SQL view that lists the POs , SKU, Product Group , Line Quantity, Outstanidng Quantity. I can summarise in Power BI as a Matrix table as follows

All I want to be able to do add a column that shows % outstanding vs the LineQuantity. Eg the last one on the list is 100% outstanding.

When I try a New Measure I get the error below? It just never seems to recognise the column names? 

I assume I need to copy this table in some way to define the columns but I dont know?! 

Help!! 

[Anonymous]

Hi  @tarrantmark ,

Whether your problem has been resolved? If yes, could you please mark the helpful post as Answered? It will help the others in the community find the solution easily if they face the same problem as yours. Thank you.

Best Regards

[Anonymous · Accepted solution]

Hi @tarrantmark ,

Please try to update the formula of your measure [%Outstanding] as below:

%Outstanding = DIVIDE ( SUM ( 'tablename'[LineQuantity] ), SUM ( 'tablename'[Outstanding] ) )

If the above one can't help you get the desired result, please provide some sample data in your tables (exclude sensitive data) with Text format and yourexpected result with backend logic and special examples. It is better if you can share a simplified pbix file. You can refer the following link to upload the file to the community. Thank you.

How to upload PBI in Community

Best Regards

[tamerj1]

Hi @tarrantmark 
You have first to add LineQty and OutstandingQty as measures. Simple SUM ( TableName[CoulmnName] ). Then you can easily DIVIDE ( [LineQty], [OutstandingQty] ). However, not sure what did you exactly mean by "Eg the last one on the list is 100% outstanding."?