Forum Discussion
question about Measure
Hi, i have encounter a problem i will appreciate your thoughts on made an example to simulate: The DB is looks like that Date Item Current Status Code Last Month Status Co...
Hi Anonymous,
>>my DB is around 2-3 million rows and i need around 10 of these
If you just want to get a summary records of each items, I'd like to suggest you use summarize function to group them and got the last val.
>>do you recommend to use LOOKUPVALUE with big DB?
As you mentioned , if you use measure to calculate through each records, it will spend the lots of system resources.
Regards,
Xiaoxin Sheng
Perhaps add an ALLEXCEPT([Item]) to your filter clause? In theory that would eliminate the Chg Code filter context in your table visualization?