Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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
Solved! Go to Solution.
Muchas gracias , me sirvio tambien a mi.
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
http://www.sqlbi.com/ AND http://www.powerpivotpro.com/
Both are great AND both have published great books!
I had been searching for a similar solution for about a week now. and had found that division was only returning the numerator in anything i was trying.
=DIVIDE(numerator, denominator, optional case) this lead me to believe that optional case was in fact optional and that it wasnt necessary. But to do a proper calculation without the divide by zero case.. it needs that ,0 option.
with scalars not of the data set i tried =DIVIDE(25,33) hoping that it would yield .75 and i was getting it to yield the numerator in return. I had tried with sums of the columns i was using etc. but i believe the appropriate thing here is that ,0 optional... if you do not need anything else in your operands that you should include the ,0 in the division formula.... as such = [numerator] / [denominator] will not yield the same result as =DIVIDE([numerator], [denominator],0)
so many SUM and SUMX and COUNTX and CALCULATE custom formulas wasted - it was a learning process though.
Thanks again for posing the question and providing the answer... now on to more difficult tasks.
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
72 | |
72 | |
38 | |
31 | |
27 |
User | Count |
---|---|
92 | |
50 | |
44 | |
40 | |
35 |