Forum Discussion

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 the column "CaseTOT" I want to receive 301 as a value.

It is possible? Thank you

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.
3.4look.pbix16 KB

3 Replies

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.
3.4look.pbix16 KB
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
  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

Related content