Forum Discussion
Power BI
Hi,
I am trying to know what is the percentage of that each row contributed to the total (349,905).
Example how to get the percentage that the 1st row contributed to the total:
Total (349,905) divided by the 1st row (35,009), multiplied by 100
(349,905/35,009)*100=6.8%
Is it possible to do this in power BI?
I was able to do it in Excel, I am trying to put it in Power BI.
Thank you,
7 Replies
Abner_ , Yes a column can be created to serve this purpose.
Also for percentage, value is divide by total and then multiplied by 100.
Thank You
I added the second column:
However, this is what I am getting, what am I doing wrong?
Abner_ what are some of the values of column 2? Try increasing the number of decimal places of column 2.
Also instead of multiplying column 2 by 100 change its data type format to percentage.
Hello Abner_ ,
Yes try the following
Percentage Per Date = Divide([Output(p2)],
CALCULATE([Output(p2)],ALL('TableThatHasDate'[Date])),0)If I answered your question, please mark my post as solution, Appreciate your Kudos đź‘Ť
Follow me on Linkedin
Vote for my Community Mobile App Idea đź’ˇIt does not let me add the table after calculate, It says that I need an expression after calculate.
Am I selecting the wrong table?
Note: I edited the header of the column, that's why when selecting the data it shows differently.
