Calculate the Net Sales and Profit

Hossam-sgiq · ‎02-03-2022

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 · ‎02-13-2022

Any updates?

Best Regards,
Eyelyn Qin

Anonymous · ‎02-08-2022

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 · ‎02-06-2022

Hi @selimovd thanks for your reply

my table as following

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 · ‎02-03-2022

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

Helpful resources