Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

How to calculate two columns based on Excel formula?

Hi guys,   I am a PowerBI noob and i would like to have your help. I  have a table that with different price group called Group A Each row on Group A has a different price which are inserted in co...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    9 years ago

    Hi Anonymous,

     

    Try this calculated field formula

     

    =if(HASONEVALUE(DFMORDERTEMPLATES[AMOUNT]),min(DFMORDERTEMPLATES[AMOUNT])*[TOTAALBETALENDLEDEN],SUMX(SUMMARIZE(DFMORDERTEMPLATES,DFMORDERTEMPLATES[AMOUNT],"ABCD",min(DFMORDERTEMPLATES[AMOUNT])*[TOTAALBETALENDLEDEN]),[ABCD]))

    Hope this helps.

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Omega

 

Thanks for your reply.

 

unfortunatly Your formula doesnt calculated the Total.

 

Would you please check the pbix file ?

 

Thanks.

 

 

 

 

Omega's avatar
Omega
Icon for Impactful Individual rankImpactful Individual
9 years ago

Anonymous

 

Can you please elaborate further? Isn't Total= Price Group A*C. 

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    HI Omega

     

    Sure mate.

     

    The Price group A is based on a column            DFMORDERTEMPLATES[AMOUNT]

    The column C is a measure based on                DISTINCTCOUNT(CUSTINVOICEJOUR[INVOICEACCOUNT])

     

     

     

    • Omega's avatar
      Omega
      Icon for Impactful Individual rankImpactful Individual
      9 years ago

      Anonymous 

       

      I don't see the PBIX file attached :(