Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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.
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.
@robertosangi , the purpose of lookup ?
Like , we can have a measure
calculate(sum(Table[CaseTOT]) , filter(Table, Table[Face protego] = "Totale complessivo"))
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
83 | |
70 | |
61 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |