Forum Discussion

voiciK's avatar
voiciK
Frequent Visitor
4 years ago
Solved

SUM - Multiple categories

Hi All,

 

I'm new to Power BI and wondering if you can help me with this sum function. I have a table like this:

 

TEST_TABLE:

TypeAmount
A10
B50
C72
A65
D75
W30
B29

 

I want to have a sum of all amounts with either Type A or Type B.

 

I tried this: TOTAL AMOUNT = CALCULATE(SUM(TEST_TABLE[Amount],TEST_TABLE[Type]="A")+SUM(TEST_TABLE[Amount],TEST_TABLE[Type]="B"))

 

But ran into the error: "Too many arguments were passed to the SUM function. The minimum argument count for the function is 1"

 

Thanks  🙂

 

Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    4 years ago

    Hi,

    Try this measure

    =CALCULATE(SUM(TEST_TABLE[Amount]),TEST_TABLE[Type]="A")+SUM(TEST_TABLE[Amount]),TEST_TABLE[Type]="B")

    or

    =calculate(SUM(TEST_TABLE[Amount]),TEST_TABLE[Type]="A"||TEST_TABLE[Type]="B")

    Hope this helps.

     

3 Replies

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    4 years ago

    Hi,

    Try this measure

    =CALCULATE(SUM(TEST_TABLE[Amount]),TEST_TABLE[Type]="A")+SUM(TEST_TABLE[Amount]),TEST_TABLE[Type]="B")

    or

    =calculate(SUM(TEST_TABLE[Amount]),TEST_TABLE[Type]="A"||TEST_TABLE[Type]="B")

    Hope this helps.