I have two tables which have the same id column. I need to add a slicer in to filter, How?

[PowerNewbee]

I have two tables which have the same id column.

I need to add a slicer to drill down on sales per salesperson.

I do not know where to start, and what my dax formula should ook like.

In sql. it would be an inner join I suppose. How to handle this problem from the start? And what would the syntax look like?

[v-kongfanf-msft · Accepted solution]

Hi @PowerNewbee ,

According to your description, you can establish the relationship between the two tables based on the ID, and then create the following MEASURE to get the sales corresponding to the salesman by filtering.

result_ = 
CALCULATE (
    SUM ( Table_[Sold] ),
    FILTER ( 'Table', 'Table'[Saler] = SELECTEDVALUE ( 'Table'[Saler] ) )
)

Best Regards,
Adamk Kong

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[qqqqqwwwweeerrr]

Hi @PowerNewbee 

you can join tab;e based on ID column to acive this you can follow instruction in this article: https://www.c-sharpcorner.com/article/merge-two-tables-in-power-bi/

Drag ID from one of the table to another one the replation will be establised and you are done 
then ho dashboard, depending on reuiqrement you can create view say add sales person in slcier and in table add sales you view is ready

If you still have confusion, please sample data here that might help to look into problem statment more clearity 

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Check for more intersing solution here: www.youtube.com/@Howtosolveprobem

Regards