Can you help me, please, with a percentage solution

[andrei_cocosatu]

Hello everyone , hope you doing great this day too , i`ve got a situatin that cannot be don by myself and i would pe proudly glad if someone could help me with this or even giving me another idea to do it. So bellow you will see some screenshots from excel but in the end they will get into PowerBi so i have to ask you first if i should do it here or with a formula in PowerBI. I have to do it percentage for different Months and i started by divide C2/B2 ( pcs divided by Prod) for each day , but in the end the value 9.83 after summing all percentages for each day it`s too much and they dont want to see that , they want to see for a entire Month like in the second screen summing all pcs divided by summing all of PROD , but i dont know how to do it in PowerBI and i might need your help , or even with another solution ( because they said it`s ok per day with the values that i`ve got but for an entire Month to be 0.29% instead of 9.83%.  Hope you can do it because i`m out of ideas.

[Anonymous · Accepted solution]

HI, 
1. Create sum of Prod, Total_Prod = SUMX(Sheet2,Sheet2[Prod])

2. Create sum of Prod, Total_pcs=Total_Pcs = SUMX(Sheet2,Sheet2[PCS])
3. Create % = DIVIDE([Total_Pcs],[Total_Prod],0)

[andrei_cocosatu]

Thank you a lot!

[Anonymous]

Welcome 😁

[Anonymous]

Hi,
is it possible to share ur demo excel file or use

DIVIDE([pcs ],[Prod],0)

[amitchandak]

@andrei_cocosatu , if that is Avg of % per day measure then try like

Averagex(Values(Table[Date]),[% Per day])

in case date table is used

Averagex(Values(Date[Date]),[% Per day])

[andrei_cocosatu]

Is not , in first is summing all % for each day and it`s 9.83 but it`s wrong , they somehow want to be 0.29 ( SUM of all pcs/ sum of all PROD ) and i PowerBi is just summing each day distinctly and it`s giving me a wrong number