Forum Discussion
Help with DAX calculation( addition and division)
I am relatively new to PowerBI and though i have created many dashboards and reports, i need help in creatiing this dax calculations in a report i am working on, i have tried several calculations and was getting the wrong results
I have two columns of data which looks as follows:
| Participants | A | B | |
| 1 | 0 | 0 | |
| 4 | 2 | 5 | |
| 3 | 12 | 0 | |
| 3 | 4 | 4 | |
| 6 | 0 | 0 | |
| 7 | 0 | 0 | |
| 12 | 2 | 0 | |
| 3 | 4 | 1 | |
| 4 | 0 | 1 | |
| 9 | 2 | 1 | |
| 1 | 1 | 0 | |
| 1 | 3 | 3 | |
| 0 | 1 | 1 | |
| Total | 54 | 31 | 16 |
The goal is to create a calculation ( measures or column) with the following intent:
1. Add the totals of columns A &B , divide the sum of columns A&B by the total of column Participants and then convert the result into a percentage i.e (31+16)/54 with results converted to percentage.
Any help will be appreciated with regards to the dax calcuation
Thanks
5 Replies
Sean
Immense thanks
I am focused on training myself on dax calculations, seeing that you are quite versed.
What are the best resources out there to get a new beginner like myself up to speed.
Thanks
SeanCommunity Champion
http://www.sqlbi.com/ AND http://www.powerpivotpro.com/
Both are great AND both have published great books!
Muchas gracias , me sirvio tambien a mi.
