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.
Hi All,
1. I have created summarize table with cutomers and sum of their disounts.
2. Created the relationship with the main table and summarized table with customer which is many to one.
3. I have applied a year slicer from the main table, the summarize table is not filtering.
Can anyone suggest me where i am going wrong or any suggestions.
Adding the file you can download : https://we.tl/t-Rn8KOEY6cE
Thanks,
Akhil.
Solved! Go to Solution.
Hi @Akhil_1411 ,
The summarize table won't be filtered in your model because it's a calculated table not a visual.
Try add year column in your summarize table.
Best Regards,
Jay
Community Support Team _ Jay Wang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Akhil_1411 ,
The summarize table won't be filtered in your model because it's a calculated table not a visual.
Try add year column in your summarize table.
Best Regards,
Jay
Community Support Team _ Jay Wang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
whats direction of your relationships? set as both
@az38 ,
I tried using both and single direction but results are not as expected when i slicer with year.
Thanks,
Akhil.
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 |
---|---|
113 | |
99 | |
80 | |
70 | |
59 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |