Show % based on 2 tables

[mdjoshua94]

Hello everyone, I have 2 different tables in my power bi that I am interested in making a pie chart. Is there any way to combine this great tgt dataset? I give an example below

Total order

1

2

3

4

5

Order	Success
1	Yes
2	Yes
3	Yes

I would like to show a pie chart of Sucess based on the Total Order column (which would obviously be 60%) but my powerbi still shows it as 100% based on the order of the columns even after the addition of many-many relationships between Order and Total Order.

How does this work with thanks!

[v-chuncz-msft · Accepted solution]

@mdjoshua94 

See solution in post below.

https://community.powerbi.com/t5/Desktop/Show-based-on-2-tables/td-p/1075652

[Greg_Deckler]

Can you add a column to Total Order like:

LOOKUPVALUE('Orders'[Success],'Orders'[Order],'Totals',[Total order])

Or MAXX(FILTER(...),...)?