PB Divide Function

[Anonymous]

Hi Everyone,

I am new to power BI and I am trying to use divide function. I want to make precentage of OTAS but my answer on PB are wrong. I check on excel it work good but not in PB.

I try to use diffrent technique but still not able to figure out. Stop No is this PB are count. I also past the excel solution which I want on PB. On excel I used count funtion for OTAS and OTAW. 

If any one know please guide.

Stop	Loads		OTAS	OTAW		OTAS %	OTAW %
1	5467		2916	4786		53%	88%
2	4030		1751	3171		43%	79%
3	1638		611	1237		37%	76%
4	594		164	422		28%	71%
5	227		44	136		19%	60%
6	81		12	32		15%	40%
7	21		2	9		10%	43%
8	3		0	1		0%	33%

[amitchandak]

@Anonymous , Can you share sample data and sample output in a table format? and formula in use as of now.

I am not sure aggregation you want. But kind of formula should work

OTAS % = divide(sum(Table[OTAS]),sum(Table[Loads]))
OTAW % =divide(sum(Table[OTAW ]),sum(Table[Loads]))

[Anonymous]

Hi Amitchandak,

Please see both power Bi and excecl data which I am trying to make on BP.

and sample data on excel.

https://stuconestogacon-my.sharepoint.com/:f:/g/personal/aamjad8961_conestogac_on_ca/EqCyQrybrRxGu1R...

This Summery report I want to make on BP.

Stop	Loads		OTAS	OTAW		OTAS %	OTAW %
1	5467		2916	4786		53%	88%
2	4030		1751	3171		43%	79%
3	1638		611	1237		37%	76%
4	594		164	422		28%	71%
5	227		44	136		19%	60%
6	81		12	32		15%	40%
7	21		2	9		10%	43%
8	3		0	1		0%	33%

[amitchandak · Accepted solution]

@Anonymous , not able to relate data with output. Still created a couple of formulas. check a file after signature. 

[Anonymous]

@amitchandak , thank you for your helop.

I created the required summery.

Thanks