Lookup value from a table

[robertosangi]

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 · Accepted solution]

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]

@robertosangi , the purpose of lookup ?

Like , we can have a measure

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

[robertosangi]

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