Forum Discussion

ValeriaBreve's avatar
ValeriaBreve
Icon for Post Partisan rankPost Partisan
3 years ago

Issue with measure

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 ma...
ValeriaBreve's avatar
ValeriaBreve
Icon for Post Partisan rankPost Partisan
3 years ago

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!