The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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.