Retrieve value from a cell and display on a card.

[Anonymous]

Hi 

I am still learning DAX and need help with the following.  I have a table with 4 columns, A, B,C, D please see below. I need to retrieve and display the value in cell B94 on a card.

Any suggestions please? 

Thank you in advance.

PhyllisN

I 

[v-alq-msft · Accepted solution]

Hi, @Anonymous 

I'd like to suggest you create an index column in 'Query Editor' as below. The pbix file is attached in the end.

Table:

You may create a measure as below.(You may replace 10 with 94 on your side)

Measure = LOOKUPVALUE('Table'[B],'Table'[Index],10)

Result:

Best Regards

Allan

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

[LeandroMedvedev]

Thank you very much!

[Anonymous]

Hi Allan ( @v-alq-msft )

Thank you for the solution provided. Yes it worked like magic.  I had responded earlier but I cannot see my previous response, where I accepted your response as the solution. I would click on the button again and hope it works.

Thanks much

Phyllis

[amitchandak]

@Anonymous ,The information you have provided is not making the problem clear to me. Can you please explain with an example.

You can filter on column and get a value

calculate(sum(Table[col C]),Table[Col A] ="Total No ..")

Can you share sample data and sample output in table format?
Appreciate your Kudos.

[Anonymous]

Hi Amitchandak

Thank you for your response.  The  cell content is manually updated i.e. it is not a "total" sum of the other cells. The problem is that I need to take the value from this cell (B94) and display it (543) on a card.  I tried the formula you gave but it gave errors. Any other suggestions please?

Thank you in advance.