Share calculation based on column output

[Anonymous]

Hi Team,

I am trying to get the share value, can you please help me.

Below is my sales.

My requirment is

for Black Tea = 7354.8/25459.4.

Please help me.

[AlB · Accepted solution]

@Anonymous 

For Sales, just select the option Show value as Percent of column total. See it all at work in the attached file.

Please accept the solution when done and consider giving a thumbs up if posts are helpful.  Contact me privately for support with any larger-scale BI needs, tutoring, etc.

[AlB]

@Anonymous 

URL to the file hosted elsewhere is fine. It just needs to be accessible without the need to log in

Please accept the solution when done and consider giving a thumbs up if posts are helpful.  Contact me privately for support with any larger-scale BI needs, tutoring, etc.

[Anonymous]

@AlB 

Here is my sample data,

Using Metrix visual and showing Maker in Row & Category in Column and Sales in Value.

Maker_SCI	Category	Sales
CC	BT	73538
CC	Co	900379.1
CC	CK	171813.9
CC	Eg	82051.6
CC	Fl	41298.3
CC	Ju	49788.7
CC	Ns	269539.4
CC	Others	14200.4
CC	Sp	61121.8
CC	Wa	121166.8
AA	BT	54817
AA	Co	397434.1
AA	CK	25115.5
AA	Eg	45378.7
AA	Fl	26116.9
AA	Ju	26425.7
AA	Ns	127688.5
AA	Others	11366.7
AA	Sp	12259.2
AA	Wa	60933.8
BB	BT	82386.6
BB	Co	117761.8
BB	CK	2620
BB	Fl	17696.1
BB	Ju	19429.9
BB	Ns	50038.8
BB	Others	19802.6
BB	Sp	29955.8
BB	Wa	15011.9
AB	BT	7998.2
AB	Co	220669.2
AB	CK	924.6
AB	Eg	24507
AB	Fl	36718.2
AB	Ju	21253.8
AB	Ns	35122.3
AB	Others	37988
AB	Sp	1955.7
AB	Wa	39972.4
IT	BT	1627.9
IT	Co	83520.2
IT	Eg	6251.2
IT	Fl	1564.8
IT	Ju	12291.5
IT	Ns	146866.3
IT	Others	4241.2
IT	Wa	8023.7
DY	BT	7705.6
DY	Co	230389.9
DY	CK	74.9
DY	Eg	3623.8
DY	Fl	8236.4
DY	Ju	22251.7
DY	Ns	23311.9
DY	Others	14360
DY	Sp	2306.8
DY	Wa	16048.1
PA	BT	11986.1
PA	Co	38937.5
PA	CK	996.5
PA	Eg	6217
PA	Fl	3706.8
PA	Ju	21426.7
PA	Ns	16114.6
PA	Others	3090.8
PA	Sp	11497.7
PA	Wa	7178.3
Others	BT	14455.4
Others	Co	98853.5
Others	CK	769.4
Others	Eg	103582.2
Others	Fl	32725.1
Others	Ju	27921.3
Others	Ns	33557.2
Others	Others	28101.7
Others	Sp	68942.7
Others	Wa	22677.2

[Anonymous]

@AlB 

Not really sure how to do that, let me know the other way to share the file 

[AlB]

Share the pbix, with dummy data if necessary

Please accept the solution when done and consider giving a thumbs up if posts are helpful.  Contact me privately for support with any larger-scale BI needs, tutoring, etc.

[Anonymous]

Here is the pbi file

https://drive.google.com/file/d/1nnp8ajrCfy4yDvrTlS69beGkje0TZM9g/view?usp=share_link.

Thanks in advance !

[AlB]

@Anonymous 

That link seems to require logging into Google. Can you remove that requirement (or share it elsewhere)?

Please accept the solution when done and consider giving a thumbs up if posts are helpful.  Contact me privately for support with any larger-scale BI needs, tutoring, etc.

[Anonymous]

@AlB 

Can you try to access the link, as I have given required access

please do let me know how can I share.

Please share your email id.

Thnks !

[AlB]

Hi @Anonymous 

Check this out

https://community.powerbi.com/t5/Desktop/How-To-Display-Percentage-of-Total/m-p/892172

Please accept the solution when done and consider giving a thumbs up if posts are helpful.  Contact me privately for support with any larger-scale BI needs, tutoring, etc.

[Anonymous]

@AlB ,

This is not working.

Below is my formula.