The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
Hello, I am working on a Gross Profit Percentage calulation. For some reason the Summary does not appear to be caculating properly. In the print screen below shows my Field, Calulation, and expected result. Not sure what I am doing wrong here as I am getting a GP% of "41" when it should be "59".
Solved! Go to Solution.
Hi @bcap01
You can try the following code, create it as a measure:
GP% = DIVIDE(SUM('Table'[Invoice])-SUM('Table'[Cost]),SUM('Table'[Invoice]))*100
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @bcap01
You can try the following code, create it as a measure:
GP% = DIVIDE(SUM('Table'[Invoice])-SUM('Table'[Cost]),SUM('Table'[Invoice]))*100
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.