Help with DAX calculation( addition and division)

[troystyle]

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
 

[Sean · Accepted solution]

@troystyle Here you go...

[Rommel]

Muchas gracias , me sirvio tambien a mi.

[troystyle]

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

[Sean]

http://www.sqlbi.com/ AND http://www.powerpivotpro.com/

Both are great AND both have published great books! 

[PMI_JJenkins]

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.