Create Divide within the table

[Siddharth_2987]

Hey Team,

I am new to PBI. I have a table where the data are available as below.

Sex	Population
Male	20
Male	10
Female	30
Trangender	5
Female	30
Trangender	10

I need to get the percentage contribution of Male w.r.t Total Population and Male population w.r.t Transgender population.

Can anyone help me!

[Ahmedx · Accepted solution]

[Ahmedx]

pls try again download

[Siddharth_2987]

Possibly issue with the Google Drive. I am still getting error.

[Ahmedx]

https://dropmefiles.com/YYx0g

[Ahmedx]

Based on your description, I created data to reproduce your scenario. The pbix file is attached in the end.

https://1drv.ms/u/s!AiUZ0Ws7G26RiSls5sxWe1b2z-fx?e=sadPEa

[Siddharth_2987]

unable to get the Pbix file. It seems no access to the file.