Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi All,
I have a table with two columns.
City | Profit |
Chicago | 60 |
Los Vegas | 80 |
New York | 40 |
Los Angeles | 90 |
Houston | 10 |
Total Profit | 280 |
I need to add one more column "Percentage %". and insert values for "Profit/Total Profit" in th new column.
Any help will be appreciated. I want to done this on Power Bi. Thanks
Solved! Go to Solution.
Hi @sdhn ,
you can do it like this:
Sum of Profit = SUM('Table'[Profit])
Percentage = DIVIDE([Sum of Profit],CALCULATE([Sum of Profit], ALL('Table')))
With kind regards from the town where the legend of the 'Pied Piper of Hamelin' is at home
FrankAT (Proud to be a Datanaut)
Hi @sdhn ,
you can do it like this:
Sum of Profit = SUM('Table'[Profit])
Percentage = DIVIDE([Sum of Profit],CALCULATE([Sum of Profit], ALL('Table')))
With kind regards from the town where the legend of the 'Pied Piper of Hamelin' is at home
FrankAT (Proud to be a Datanaut)
@sdhn , new column
divide(Table[Profit],sum(Table[Profit]))
Table real name is MailPackage and Column name is MAIL COUNT instaed of Profit.
I am getting following message.
I right clicked on Table and choose New Column and insert following code:
The syntax for 'sum' is incorrect. (DAX(DIVIDE(MailPackage[MAIL COUNT]sum(MailPackage[MAIL COUNT])))).
Your help will appreciaed again. Thanks
I added "," before sum and its work BUT
Please note:
I have a total of mail count (Profit in above example) in the last row.
It is 280 in above example.
I want to get result of percentage as mail counts/total mail counts * 100 for each row in the newly percentage column as below:
60/280*100
80/280*100
40/280*100
90/280*100
10/280*100
Thanks
It is ok. I removed the total from the source file. I appreciate your help. thx
Try Column = DIVIDE( MailPackage[MAIL COUNT], SUM(MailPackage[MAIL COUNT] )
No DAX required.
User | Count |
---|---|
140 | |
113 | |
104 | |
76 | |
63 |
User | Count |
---|---|
135 | |
126 | |
110 | |
70 | |
61 |