Sumproduct multiple column (Dax Req)

[Saxon10]

Hi,

In data table I have 3 columns are A,B and C, based on the columns I am trying to calculate the volumn of each bins.

I am applying the following formaula =IF(A2*B2*C2=0,0,SUMPRODUCT(($A$2:$A$13*$B$2:$B$13*$C$2:$C$13>=$A2*$B2*$C2)+0)) in Excel. How can I apply the same logic in Power BI.

I am looking for new calculate column option.

Any idea please.

A	B	C	RESULT
420	600	440	11
640	600	480	9
890	1100	1330	2
1335	1100	2350	1
890	1100	390	5
890	1100	530	3
670	1100	540	4
670	1100	440	6
320	1100	440	10
600	400	400	12
800	600	400	8
1000	600	500	7

Data and Result snapshot:

[CNENFRNL · Accepted solution]

For your reference,

Result = IF(DS[A]*DS[B]*DS[C], RANKX(DS, DS[A]*DS[B]*DS[C]), 0)

[Saxon10]

Hi.

Thanks for your reply and help. Your solution working fine.