Forum Discussion

Saxon10's avatar
Saxon10
Icon for Post Prodigy rankPost Prodigy
5 years ago
Solved

Sumproduct multiple column (Dax Req)

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...
Need Help
  • CNENFRNL's avatar
    CNENFRNL
    5 years ago

    For your reference,

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

CNENFRNL's avatar
CNENFRNL
Icon for Community Champion rankCommunity Champion
5 years ago

For your reference,

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

  • Saxon10's avatar
    Saxon10
    Icon for Post Prodigy rankPost Prodigy
    5 years ago

    Hi.

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