Total sellers by project and date

[kasife]

Hello everyone. How are you?

I'm having trouble getting an indicator, because I don't know if my modeling is correct.

I have a bridge table, because I have many-to-many tables, that is, a broker can work in 1 or more projects and a project can have one or more salespeople.

The thing is, I can't get the total salesperson result by project and month-year. I would like to consider the filters on the screen.

Here's an example of the solution I would like:

In 04/2024, project A had a total of 50 sales, 10 salespeople and of those 10, only 5 made sales.

In 05/2024, project A had a total of 70 sales, 15 salespeople and only 10 made sales.

I can't get this result of the total salesperson when I filter the project and the date. Could someone help me?

The file is in the following link: https://ufile.io/3vt6lefd 

[v-xinruzhu-msft]

Hi @kasife 

Based on your file, the id column in your _repasses table is different from the id column in your _equipeVenda table

After testing, when you filter the id in _equipeVenda  table, the _repasses returns blank.

Best Regards!

Yolo Zhu

[kasife]

@v-xinruzhu-msft Thank you very much for the return. In the _repasses table, the column that is equivalent to _equipesvendas is idcorretor.