Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

Reply
mohammedksa
Frequent Visitor

Income Statement using Matrix need to divide line item & sub Category by Sales Volume

https://drive.google.com/file/d/1owymynRhG_3hpmxG9KxJfrohobCVmIK8/view?usp=drive_link 

Dear Experts, 

I am preparing Income Statement related to Readymix Industry which has multiple location. I want to divide all the line items with Quantity sold to identify the cost per Unit( Cubic Meter M3). Income statement layout is perfect, Location with Slicer is working properly, Grandtotal include sales volume which i have excluded from Total, First issue were i am facing is dividing sales volume with all the line items and sub line items, Second problem is expense item are in Negetive  and so the value divide are giving Negative value need to avoid Negative sign. I am enclosing the  pbix file for ready reference.

Appreciate, Any one can assist me in finding solution.

Thanking you in advance. 

 

 

3 REPLIES 3
Ashish_Mathur
Super User
Super User

Access Denied message.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

What exactly are you trying to share???   That is a 3.7GB .rar file?  Sorry not interested.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

Helpful resources

Announcements
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.