Forum Discussion
Raul
Post Patron
4 years agoOptimise a SELECTEDVALUE formula
Hello community, I have a matrix visual where for each category and item 3 columns of text type and the sales amounts are shown. Id.Item EAN UxB Amount cat1 4.250 ...
amitchandak
Super User
4 years agoRaul , try if this can improve it a bit
Id.Item =
IF(ISINSCOPE(Items[Item]), max(Items[Id.Item]), BLANK())
Raul
Post Patron
4 years agoThanks for your reply but, in my case, the result it's the same.