Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
Hi, I have a source table that has tickets created against creation dates, I have created a date table with all distinct dates.
Now I want to create a measure that gives me total ticket counts against each date. I tried multiple measures but everytime I am getting overall total count against each date in reapeated manner. Like if total tickets in the file are 5000, I get 5000 against each date.
Please help, Thanks !
That sounds like the relationship between the tickets table and the date table is missing or not setup correctly. Please take a look. There should be a valid relationshp between those two tables for your measure to work.
User | Count |
---|---|
5 | |
3 | |
3 | |
2 | |
2 |
User | Count |
---|---|
9 | |
3 | |
3 | |
2 | |
2 |