Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
If axis is any other field, counts work. But when I use Week Ending from my Date table or Week Ending from a calculated field in my primary table, all counts are 1. I've tried count and count distinct on various columns and it is always 1. My Date Table alone works fine and shows Week Ending and there is a relationship between it and my primary table.
The information you have provided is not making the problem clear to me. Can you please explain with an example. If possible please share a sample pbix file after removing sensitive information.
Thanks
User | Count |
---|---|
102 | |
91 | |
87 | |
79 | |
71 |
User | Count |
---|---|
113 | |
105 | |
101 | |
75 | |
64 |