Forum Discussion
Community ChampionOptimizing search for simultaneous logins - Slow measure
Yes.
I tried calculated column with 520k+ rows, it takes 1min or so to load and calculate; I think it's worthwhile. On one hand, the attribute of a specific session is static; on the other hand, measures to slice and dice the data model on the fly takes a blink of an eye only.
Community ChampionThanks CNENFRNL
Good points.
1. I've added some mock data
2. The actual table has many more than those 4 more columns. That's why I'm using the SUMMARIZE, as a way to grab only the columns I need. I guess we could use something like SELECTCOLUMNS, but don't think that will have a significant performance impact
Community ChampionFrankly speaking, I didn't catch the underlying logic of your measure because your measure evaluates like this, which seems unlogical to me,
I replicate the logic in calculated column for debugging,