cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
lisa01bh Occasional Visitor
Occasional Visitor

Need to Add a Row Based on different field from Same Column

I am new to Power BI and I am trying to  add new row Gross profit just based on cost and sales and get the results below. Any help is appreciated. Thanks

Gross profit.JPG

1 REPLY 1
v-huizhn-msft Super Contributor
Super Contributor

Re: Need to Add a Row Based on different field from Same Column

Hi @lisa01bh,

In Power BI, the basic cell is a column. We can't add a row in a table. We only can add a column. For your scenario, you can create a measure and a card visual to display the result.

Gross profit =
CALCULATE ( SUM ( Table[Budget] ), FILTER ( Table, Table[Category] = "Sales" ) )
    - CALCULATE (
        SUM ( Table[Budget] ),
        FILTER ( Table, Table[Category] = "Income" )
    )


Best Regards,
Angelia