Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Solved! Go to 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.
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.
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: https://www.youtube.com/@letssolveproblem
Regards
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
39 | |
25 | |
20 | |
14 | |
8 |
User | Count |
---|---|
71 | |
48 | |
46 | |
20 | |
16 |