Forum Discussion
Solved
Show % based on 2 tables
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!
See solution in post below.
https://community.powerbi.com/t5/Desktop/Show-based-on-2-tables/td-p/1075652
2 Replies
- Can you add a column to Total Order like:
LOOKUPVALUE('Orders'[Success],'Orders'[Order],'Totals',[Total order])
Or MAXX(FILTER(...),...)? See solution in post below.
https://community.powerbi.com/t5/Desktop/Show-based-on-2-tables/td-p/1075652
