Forum Discussion

robertosangi's avatar
robertosangi
Helper I
4 years ago
Solved

Lookup value from a table

Hi guys,    I have a simple problem that I'm not able to solve. I need to lookup all values present in the row which have "Totale complessivo".  So if I need for example the number from t...
Need Help
  • v-yanjiang-msft's avatar
    v-yanjiang-msft
    4 years ago

    Hi robertosangi ,

    According to your description, here's my solution.

    Create a measure.

    Measure = LOOKUPVALUE('Table'[CaseToT],'Table'[Fast Progetto],"Totale complessive")

    Get the expected result.

    I attach my sample below for reference.

     

    Best Regards,
    Community Support Team _ kalyj

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-yanjiang-msft's avatar
v-yanjiang-msft
Community Support
4 years ago

Hi robertosangi ,

According to your description, here's my solution.

Create a measure.

Measure = LOOKUPVALUE('Table'[CaseToT],'Table'[Fast Progetto],"Totale complessive")

Get the expected result.

I attach my sample below for reference.

 

Best Regards,
Community Support Team _ kalyj

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.