Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 😞
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
99 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
110 | |
91 | |
84 | |
66 |