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

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

PowerNewbee — Wed, 17 Apr 2024 12:45:18 GMT

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?

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

qqqqqwwwweeerrr — Sat, 22 Jun 2024 05:50:13 GMT

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

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

Anonymous — Tue, 23 Apr 2024 07:58:35 GMT

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.