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