Percentage of products sold, from totals from another file

[Inverno]

Hello guys.

I'm struggling with this topic and i'm bugging out. Perhaps you can help me with it.

I'm working with 2 files.

File 1 - Year 2022 total products quantity (sold and not sold) aprox 6000

FIle 2 - Year 2022 total products quantity not sold aprox 2000

Both files have 23 different products (the same on each file)

I want to know, via chart, the percentage of "not sold" by product (data coming from file 2) from the total ammount by product (data coming from file 1).

This is easy on other platforms e.g. excel, but in Power BI I can't seem to find it. Rookie here...

Thank you in advance.

[lbendlin · Accepted solution]

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

[lbendlin · Accepted solution]

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

[Inverno · Accepted solution]

I've managed to find a way by creating two SUM measures and dividing them. Also, setting up relationships between column files.

I'll be more carefull with my future enquiries.
Thank you for the info.