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.

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

Create a measure called Total: 

 

Total = SUM(Table1[Price Group A])*SUM(Table1[C]) 

 

Create a table and drag all the columns including total. 

 

  • 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])