Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
This problem seems simple, but I'm struggling to find a robust solution. I'm modelling person-to-person transactions, where a person can be either a sender or a receiver. I need a single visual slicer that will return transactions where either the sender OR the receiver belonged to a given region.
I've got two tables:
My previous solution was:
That solution is falling apart as I attempt to create measures that use both tables (i.e. filter on Region, create stacked column chart that a) count distinct Sender.IDs that appear in Transaction Table, and b) Person.IDs in Person table that don't appear in Transaction Table).
Any suggestions?
Solved! Go to Solution.
You may refer to the following post.
You may refer to the following post.
User | Count |
---|---|
107 | |
89 | |
81 | |
76 | |
73 |
User | Count |
---|---|
112 | |
104 | |
96 | |
74 | |
66 |