Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi
I need some expertise on this following challenge i am facing.
I have data from 2 different Queries:
Query A: There are 43 columns in total.
Query B: There are 5 columns in total
What i need is to use one slicer to pick up data from both these Queries.
I mananged to establish a relationship between these 2 Queries with the "Benefit-Benefit Country" coloumn that is present in both the Queries in the hopes that my data gets pulled out by Slicer but unfortunately nothing.
Kindly assist.
Thanks.
Solved! Go to Solution.
Hello
Try creating a dimension table like this:
Dimension Table = DISTINCT(SELECTCOLUMNS(QueryB,"Benefit-Benefit Country",QueryB[Benefit-Benefit Country]))
Next, create your relationships as one-to-many:
Choose the [Benenfit-Benenfit Country] column as the slicer, when you select a value in it, the slicer will filter the two other tables:
I hope this helps.
Best regards
Giotto Zhi
Hello
Try creating a dimension table like this:
Dimension Table = DISTINCT(SELECTCOLUMNS(QueryB,"Benefit-Benefit Country",QueryB[Benefit-Benefit Country]))
Next, create your relationships as one-to-many:
Choose the [Benenfit-Benenfit Country] column as the slicer, when you select a value in it, the slicer will filter the two other tables:
I hope this helps.
Best regards
Giotto Zhi
Hi there,
Have you tried creating a dimension table for the Benefit-Benefit (B-B) countries?
- Create a new table containing only the unique B-B values and load to the model.
- Remove relationship between your two original tables
- Add two new relationships from your new dimension table to the two original tables
- Dimension side should be 'one', fact table sides should be 'many', filter direction from dimension to fact
- Now use you new dimension table to populate the slicer. This should filter both queries on the one slicer.
Proud to be a Datanaut!
User | Count |
---|---|
92 | |
85 | |
77 | |
66 | |
62 |
User | Count |
---|---|
110 | |
95 | |
95 | |
64 | |
59 |