Hello,
I've submitted this question already but it never appeared so I have to submit it again.
I'm stumped again. I've spent the last couple hours reading the forums and nothing helped. What I'm trying to do is create a chart that will show data from these two tables, but I can only get the data from one table to work as I expect it to.
I created some sample data to show what I'm trying to do. Here is the Orders table:
| Branch | Customer | Revenue |
| ABC | Arby's | $5 |
| DEF | McDonald's | $10 |
| XYZ | Arby's | $15 |
| ABC | Wendy's | $10 |
| DEF | McDonald's | $5 |
| XYZ | Wendy's | $20 |
| ABC | Arby's | $15 |
| DEF | McDonald's | $10 |
| XYZ | Arby's | $5 |
| ABC | Wendy's | $15 |
| DEF | McDonald's | $25 |
| XYZ | Wendy's | $15 |
Here is a "Stops" table:
| Branch | Customer | Scanned |
| ABC | Arby's | Y |
| DEF | McDonald's | Y |
| XYZ | Arby's | N |
| ABC | Wendy's | N |
| DEF | McDonald's | Y |
| XYZ | Wendy's | Y |
| ABC | Arby's | N |
| DEF | McDonald's | Y |
| XYZ | Arby's | N |
| ABC | Wendy's | Y |
| DEF | McDonald's | Y |
| XYZ | Wendy's | Y |
These tables are linked indirectly by a third table called "Branches", which just has each unique branch. I also created a Customers table with each unique customer and linked them together that way, but that made no difference.
I have a Splicer that let's you select each Branch, and when you do, it will show the revenue for that branch for each customer.
What I want is when you select the splicer for "ABC", it will show a table like this:
| Customer | Revenue | Scanning |
| Arby's | $20.00 | 50% |
| McDonald's | $0.00 | 0 |
| Wendy's | $20.00 | 50% |
It works with Revenue and the numbers come out properly, but for Scanning it only comes out to 66% for each line (taking the total values and not paying attention to the customer).
What am I doing wrong? How do I create a column or measure that will pay attention to the customer for this second table?
Sorry, DAX is a bit of a learning curve!
