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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

Calculate profit for every client individually

Hey PowerBi Community, I have a simple beginners question.

 

I have a table with 6 columns: client, invoice number, date, quantity, sales price and cost to manufacture (profit is a measure: quantity*sales price-quantity*cost to manufacture). I want to create a measure that displays total profit by client next to each invoice (order), is that possible?

 

Thanks in advance,

Zenons

1 ACCEPTED SOLUTION

Hi @Anonymous ,

 

You may create measure like DAX below .

 

Profit =
VAR _Quatity =
    CALCULATE (
        SUM ( Table1[quantity] ),
        ALLEXCEPT ( Table1, Table1[client], Table1[invoice number] )
    )
RETURN
    _Quatity
        * ( MAX ( [sales price] ) - MAX ( [cost to manufacture] ) )

Best Regards,

Amy 

 

Community Support Team _ Amy

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

View solution in original post

4 REPLIES 4
amitchandak
Super User
Super User

@Anonymous ,  Try

new column = [quantity]*([sales price]-[cost])

new measure = sumx(table, [quantity]*([sales price]-[cost]))

Anonymous
Not applicable

@amitchandak Both new column and new measure just show profit for every order next to the invoice number, but I want to see the total profit from the client that made the order next to the invoice number.

Hi @Anonymous ,

 

You may create measure like DAX below .

 

Profit =
VAR _Quatity =
    CALCULATE (
        SUM ( Table1[quantity] ),
        ALLEXCEPT ( Table1, Table1[client], Table1[invoice number] )
    )
RETURN
    _Quatity
        * ( MAX ( [sales price] ) - MAX ( [cost to manufacture] ) )

Best Regards,

Amy 

 

Community Support Team _ Amy

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

harshnathani
Community Champion
Community Champion

HI @Anonymous ,

 

 

Total Sales = SUM(Table[Sales])

Total Cost = SUM(Table [Cost])

 

Profit = [Total Sales] - [Total Cost]

 

Regards,
Harsh Nathani
Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.