Relationship option between tables + Calc with columns

[brunozanoelo]

Hello everyone, I am filling some doubts and if they help me I would be VERY grateful ...

Next, today I have a sales chart, which contain customer codes, sellers ...

Today, I do not use the relationship option between tables, so the names of customers and sellers are in the sales chart. Which, in my opinion, is wrong because it is duplication of information.

My case is this: If I create the tables and bind them, while filtering the customer data, it will only display the sales of the clients that I've filtered, correct?

Until then, okay.

Now, in a calculation case, I need to make an average sales ticket by doing:

Total sales (Sales table column) / Number of customers in the sellers' portfolio (Sellers table column)

Is there any way I can do a calculation working with multiple tables? In this case I would take the value of sales from the sales table and the quantity of customers by another table.

[Phil_Seamark]

Hi @brunozanoelo,

First of all DAX is a very powerful language and you will be able to create measures that will return the metrics you are expecting.

Most DAX can be very simple, but when required, you can develop some quite sophisticated measures.

If you'd like some help, then please post a sample of your data including what you expect to see for your measures and we will do our best to help.