Forum Discussion

Raul's avatar
Raul
Icon for Post Patron rankPost Patron
4 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
v-xiaotang's avatar
v-xiaotang
Icon for Community Support rankCommunity Support
4 years ago

Hi Raul 

Have you solved this problem? If yes, to help others find answer faster, could you kindly accept the answer helpful as the solution? Or could you kindly share your solution to improve Power BI?
Really appreciate!
Any question, please let me know. Looking forward to receiving your reply.


Best Regards,
Community Support Team _Tang

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

    Hi v-xiaotang and amitchandak ,

    No, the option to change the SELECTEDVALUE with MAX did not solve my problem. It does solve it if I filter the records with a filter, but it doesn't work for me. The real problem is that I have 4 columns with this problem and that's why I get the error. I had to remove them from the matrix and put their values as row data.
    Thanks anyway.