Forum Discussion
Measure for sum when match between two tables
I have two table with related columns and perform action Table 1 (Spend): Category Supplier Spend Motor ABB 5000 Drive ABB 6000 Drive Siemens 8000 Cable ABB 9000 M...
HI
My resolution:
1. add a customer column in sheet 2, named as your request, such as " perfect choice"... and filled with “yes”
2. merge sheet2 to sheet 1 when category and supplier are both matched in the two sheet. and get the "yes" column
3. add new quick measure-filted value: calculate the speed column,by filte "yes" column. named "yes value".
4. add new quick measure-division: get (SUM Speed)/ (SUM yes value). it is 0.53.
sorry,I don't have resource to update the my screen picture. wish it helpful.