calculate amount from just several row values

[OliJov]

I have table with 10.000 rows, and I need to calculate ammount:

iop1001/iop5628 +iop5885+iop9000 , how I do that? That measures then is affected by dimensions.

iop        amount

1001      252

1002      323

1003      525

1004      787

...

10000     969

[v-zhangti · Accepted solution]

Hi, @OliJov 

You can try the following methods.

Measure = 
Var _iop1001=CALCULATE(SUM('Table'[amount]),FILTER(ALL('Table'),[iop]=1001))
Var _iop5885=CALCULATE(SUM('Table'[amount]),FILTER(ALL('Table'),[iop]=5885))
Var _iop9000=CALCULATE(SUM('Table'[amount]),FILTER(ALL('Table'),[iop]=9000))
Return
_iop1001+_iop5885+_iop9000

Is this the result you expect?

Best Regards,

Community Support Team _Charlotte

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