Calculate the Net Sales and Profit

[Hossam-sgiq]

Hi All i am new in pwoer BI

I Have issue which i can not solve 

i have transaction data with carsSales , Truck Sales  and also discountcars , discount truck .

i want to calculate the net sales out of these transaction and put is in matricx like 

net Sales Truck  = 500

disc Sales Truck = 100

Net Sales Truck = 400

can anyone help me in this

Thanks

[Anonymous]

Hi @Hossam-sgiq ,

Any updates?

Best Regards,
Eyelyn Qin

[Anonymous]

Hi @Hossam-sgiq ,

What's your expected output?

Based on my test, I have create measures to calculate the Total Sales and Total discount for each Account on each Day:

As you can see, they are not in a same hierarchy, so how could I calculate the net sales ?

Can you please share more detail information especially the expected output to help us clarify your scenario?

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Hossam-sgiq]

Hi @selimovd  thanks for your reply 

my table as following 

Account	Date	Value	Group
1123	01-01-2020	500	Truk Sales
1123	01-02-2020	400	Truk Sales
2223	01-01-2020	50	Truk Discount
2223	01-02-2020	30	Truk Discount
1145	01-01-2020	600	Vehicle Sales
1145	01-01-2020	800	Vehicle Sales
2245	01-01-2020	200	Vehicle Discount
2245	01-01-2020	100	Vehicle Discount

so i want to add matrix to show:  total Sales , Total discount , Total Net Sales

how to show the net sales as row . thanks

[selimovd]

Hey @Hossam-sgiq ,

you can do the sum of each column and then subtract them. Try the following approach:

Net Sales Truck Measure =
SUM ( myTable[net Sales Truck] ) - SUM ( myTable[disc Sales Truck] )

If you need any help please let me know.

If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up.

Best regards

Denis

Blog: WhatTheFact.bi

Follow me: twitter.com/DenSelimovic