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.

amitchandak's avatar
amitchandak
Super User
4 years ago

robertosangi , the purpose of lookup ?

 

Like , we can have a measure

calculate(sum(Table[CaseTOT]) , filter(Table, Table[Face protego] = "Totale complessivo"))

  • robertosangi's avatar
    robertosangi
    Helper I
    4 years ago

    Hi amitchandak ,

     

    I don't need to sum. I need only to pick the corresponding value of the cell of the column which corresponds to the row having "Totale complessivo".

    As you show, it din't give me the value I needed.

    In the example, how can I catch the vale 301 refering to the "Totale complessivo" row?

    Thanks