Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to 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.
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
Hi @Anonymous,
You can upload your pbix file on onedrive and attach the shared link here.
Regards,
Yuliana Gu
Hi @Anonymous,
Try this
=min(DFMORDERTEMPLATES[AMOUNT])*[TOTAALBETALENDLEDEN]
Hope this helps.
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.
Hi @Anonymous,
Your bracketing is wrong. Close the MIN bracket before the *.
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?
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.
Create a measure called Total:
Total = SUM(Table1[Price Group A])*SUM(Table1[C])
Create a table and drag all the columns including total.
Thanks for your reply.
unfortunatly Your formula doesnt calculated the Total.
Would you please check the pbix file ?
Thanks.
@Anonymous
Can you please elaborate further? Isn't Total= Price Group A*C.
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])
@Anonymous
I don't see the PBIX file attached 😞
User | Count |
---|---|
98 | |
90 | |
82 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
67 |