Forum Discussion

Raul's avatar
Raul
Icon for Post Patron rankPost Patron
5 years ago

Optimise 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      ...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

Raul , try if this can improve it a bit

Id.Item =
IF(ISINSCOPE(Items[Item]), max(Items[Id.Item]), BLANK())

 

 

  • Raul's avatar
    Raul
    Icon for Post Patron rankPost Patron
    5 years ago

    Thanks for your reply but, in my case, the result it's the same.