Sumifs DAX formula referencing another column

[EugenioBeltran]

Hello I am new to DAX and I am looking for a formula that is the equivalent of a sumifs referencing another column in example =sumifs(cases,sales order,@sales order). i have tried calculate(sum(table1[cases],filter(table1,table1[sales order]), in this case I have hundreds of sales orders

sales order item cases

1                 a         5

1                  b        10

1                  c         8

2                  a        27

2.                 b        35

2.                 c        15

3                  a        6   

3                  b        17

3.                  c        24

Thank you un advance

[FreemanZ · Accepted solution]

hi @EugenioBeltran 

you can plot a table visual with sales order column and a measure like:

measure = sum(table1[cases])