Forum Discussion

CornelisV's avatar
CornelisV
Icon for Helper IV rankHelper IV
1 year ago
Solved

How to get a cell string from a row in Measure

Dear all,

 

Could you please demomnstrate me for this question:

 

DescriptionScore
Dry?No
Overprocessing?Yes
Environment?No
Harmless?Yes

 

I want to create a Measure and if to pick the core from column "Score" when I use the Descriptrion = "Overprocessing".

Something like this will not help:

_My string =
CALCULATE(MIN('Table'[Scxore]),'Table'[Description]= "Overprocessing?")
 
What is the correct definition vor Measure?
 
Thank you,
 
Cornelis
Need Help
  • pankajnamekar25's avatar
    pankajnamekar25
    1 year ago

    Hello CornelisV 

    You can try this measure

    MyString =
    LOOKUPVALUE(
    'Table'[Score],                       // Column to return
    'Table'[Description],               // Search column
    "Overprocessing?"                //Search value
    )

     

    Thanks,
    Pankaj

    If this solution helps, please accept it and give a kudos (Like), it would be greatly appreciated.

  • uzuntasgokberk's avatar
    uzuntasgokberk
    1 year ago

    Hello CornelisV ,

     

    Additionally, here’s the measure that will achieve the outcome you’re looking for:

    Overprocessing Score =
    CALCULATE(
    SELECTEDVALUE( YourTable[Score] ),
    FILTER(
    YourTable,
    YourTable[Description] = "Overprocessing?"
    )
    )

     

    Kind Regards,
    Gökberk Uzuntaş

    📌 If this post helps, then please consider Accepting it as a solution and giving Kudos — it helps other members find answers faster!

    🔗 Stay Connected:
    📘 Medium |
    📺 YouTube |
    💼 LinkedIn |
    📷 Instagram |
    🐦 X |
    👽 Reddit |
    🌐 Website |
    🎵 TikTok |

4 Replies

  • pankajnamekar25's avatar
    pankajnamekar25
    Icon for Super User rankSuper User
    1 year ago

    Hello CornelisV 

    You can try this measure

    MyString =
    LOOKUPVALUE(
    'Table'[Score],                       // Column to return
    'Table'[Description],               // Search column
    "Overprocessing?"                //Search value
    )

     

    Thanks,
    Pankaj

    If this solution helps, please accept it and give a kudos (Like), it would be greatly appreciated.

    • CornelisV's avatar
      CornelisV
      Icon for Helper IV rankHelper IV
      1 year ago

      Hello pankajnamekar25 

       

      Thank you, thsi is helpful. The lookup funcion is a good alternative and a bit simpler.

       

      Best vregards,

       

      Cornelis

  • uzuntasgokberk's avatar
    uzuntasgokberk
    Icon for Super User rankSuper User
    1 year ago

    Hello CornelisV ,

     

    Additionally, here’s the measure that will achieve the outcome you’re looking for:

    Overprocessing Score =
    CALCULATE(
    SELECTEDVALUE( YourTable[Score] ),
    FILTER(
    YourTable,
    YourTable[Description] = "Overprocessing?"
    )
    )

     

    Kind Regards,
    Gökberk Uzuntaş

    📌 If this post helps, then please consider Accepting it as a solution and giving Kudos — it helps other members find answers faster!

    🔗 Stay Connected:
    📘 Medium |
    📺 YouTube |
    💼 LinkedIn |
    📷 Instagram |
    🐦 X |
    👽 Reddit |
    🌐 Website |
    🎵 TikTok |

    • CornelisV's avatar
      CornelisV
      Icon for Helper IV rankHelper IV
      1 year ago

      Hello uzuntasgokberk ,

       

      Thank you for your swift reply, this is greatly appreciated!

       

      Best regards,

       

      Cornelis