How to calculate two columns based on Excel formula?

[Anonymous]

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 column price group A. 

I need to create a table in PowerBI for calculating the column Total. the excel formula ot the Total is price group A  multiply column C.

Any suggestions to make this happens in PowerBI? do i need to make a calculated column or a measure? any examples would be grateful.

Many thanks!

Rega

[v-yulgu-msft]

Hi @Anonymous,

If [price group A] is a column, and [C] is a measure, you only need to create a measure like below to calculate the multiply value.

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

To help us better understand your scenario, please provide detailed data in source table and show us all necessary formulas you have used in this report.

Regards,
Yuliana Gu

[Anonymous]

Hi @v-yulgu-msft,

Thanks for your reaction. how can i share my pbix files to you?

[v-yulgu-msft]

Hi @Anonymous,

You can upload your pbix file on onedrive and attach the shared link here.

Regards,
Yuliana Gu

[Anonymous]

Hi @v-yulgu-msft,

here's the link

https://1drv.ms/u/s!ApQVF85_XaxchkJedVai6AAm-IrL

[Ashish_Mathur]

Hi @Anonymous,

Try this

=min(DFMORDERTEMPLATES[AMOUNT])*[TOTAALBETALENDLEDEN]

Hope this helps.

[Anonymous]

Hi @Ashish_Mathur,

thanks for your response. Unfortunatly it didnt work.

Please see the image below. The MIN function only accepts a column reference as an argument.

[Ashish_Mathur]

Hi @Anonymous,

Your bracketing is wrong.  Close the MIN bracket before the *.

[Anonymous]

Hi @Ashish_Mathur,

Thanks now its working on the right way. But i dont see the total sum on the column measure on the last row. It just give a €0.00 as total.

Any suggestions?

[Ashish_Mathur · Accepted solution]

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]

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]

@Omega

Thanks for your reply.

unfortunatly Your formula doesnt calculated the Total.

Would you please check the pbix file ?

Thanks.

[Omega]

@Anonymous

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

[Anonymous]

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]

@Anonymous 

I don't see the PBIX file attached 😞