Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hello,
I am really a beginner in DAX...
I am working with a ticketing system. I have a table that has all ticket details one by one, which is fine.
I would like to build a measure so that I can make a distinct count of the tickets, but when the user selects one row of the above detailed table, it does not resolve to "1" - so the selected ticket - but calculates back the number of tickets for the location, business and year of the selected ticket.
I also have a date table that is related to my tickets table on the date (and is working correctly)
So I came up with:
Hello, all data is confidential and creating an ex. would be very time consuming, I hoped my mistake would be evident from the measure...
I found a lead though. I have tried to use the date/year field from the tickets table directly (not the date table), and then it works. It looks like the part of my measure that is not working is related to the second ALLEXCEPT related to the datetable.
Is it not allowed to bring in a related table in ALLEXCEPT? Or to have 2 ALLEXCEPTS in the same calculate?
Thanks a lot. If it is not solvable as is, I will try to come up with mock data, but it is going to take some time.
Thanks!
Check out the July 2025 Power BI update to learn about new features.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
User | Count |
---|---|
23 | |
10 | |
10 | |
9 | |
7 |