Forum Discussion
campelliann
Post Patron
4 years agoInactivating Relationship DAX differs from Physically inactivation
Hi there, In the below measure the result is not quite the expected (very subtle difference), but if I physically inactivate the relationship between Table TicketStatus and Tickets the result is...
campelliann
Post Patron
4 years agoHi there tamerj1 , but what is the difference between my "solution 1 and solution 2". Why does Crossfilter none in the "middle" of the calculate does not work ( I have used this way many times), but wrapping around in solution 2 does work? Does it have to do with evaluation order or something?
Many thanks
tamerj1
Community Champion
4 years agocampelliann
No they're supposed to be applied at the same time. But this may not be possible technically therefore, need to be applied in two steps using two CALCULATE's