Get help to amend my syntax

Question

I have two separate syntax to sum up value. Could anyone help me to combine the syntaxs in one go?

Answer 1

Hi,

To combine these into a single expression, you can use the AND function within the CALCULATE function to include both conditions:

TOTAL_COMBINED = CALCULATE(
    SUM('Ledger'[Net]),
    'Ledger'[Category] = SELECTEDVALUE(IsStructure[Category]),
    'Ledger'[Row Index] = SELECTEDVALUE(IsStructure[Row Index])
)

Just checking in to see if the information was helpful. Please let us know if you would like further assistance.

---

If the response is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

Hi,

To add measures for "Earnings Before Interest and Tax (EBIT)" and "Net Profit" in DAX, you can use the following syntax:

Earnings Before Interest and Tax (EBIT)

EBIT = 
CALCULATE(
    SUM('Ledger'[Net]),
    'Ledger'[Category] = "Revenue"
) - 
CALCULATE(
    SUM('Ledger'[Net]),
    'Ledger'[Category] = "Expenses"
)

Net Profit

Net_Profit = 
CALCULATE(
    SUM('Ledger'[Net]),
    'Ledger'[Category] = "Revenue"
) - 
CALCULATE(
    SUM('Ledger'[Net]),
    'Ledger'[Category] = "Expenses"
) - 
CALCULATE(
    SUM('Ledger'[Net]),
    'Ledger'[Category] = "Interest"
) - 
CALCULATE(
    SUM('Ledger'[Net]),
    'Ledger'[Category] = "Taxes"
)

Hope the information is helpful.

---

If the response is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.