Forum Discussion
Calculated column based on measure - not working as expected
Hello again! I've worked out what the problem is, and why it used to work. It was actually because the relationship between AllContacts and AllEventBookings had been broken, so the part of the measure looking at LastEventBookingDate was displaying the same value for absolutely everybody. I've now fixed this and it seems to be working as it used to - phew! Thank you for spurring me on to break the problem down and look at each component - not sure I would have persevered!
Ah, I see. OK, I've just done that, but it still displays the latest date for the entire dataset, not for each individual:
I suppose this might be because the measure is built on other measures - so perhaps I will have to make calculated columns for each of them! Weird how this used to work - I'm not sure what could have changed, but perhaps I'll never know!
Community Championok, happy to see my 1st guess was right 🙂 in the 1st comment I sent
"You didn't share the measure itself, but my guess is that your measure returns the max of everyone somehow. As it is a measure on a column there is context transition so all the values in that row become the filter context. Put only the measure on a column and see what is the result and update me"
I'm sure it's not hard to solve but I think best If I will see the model.
We can do a zoom / teams if you want
Hello again! I've worked out what the problem is, and why it used to work. It was actually because the relationship between AllContacts and AllEventBookings had been broken, so the part of the measure looking at LastEventBookingDate was displaying the same value for absolutely everybody. I've now fixed this and it seems to be working as it used to - phew! Thank you for spurring me on to break the problem down and look at each component - not sure I would have persevered!