Putting a Row Value into a Card Visual

[Werbenmanjensen]

Hello, 

I am struggling with something that seems like it should be so easy, but I cannot find a solution on the forums or online. I am trying to pull a specific value from a row in a table and put it onto a card. I want to pull for instance AQC Tested value "3273" and have the "3273" show up on a card visual. Every code variation I have tried in DAX from HASONEVALUE, VALUE, CALCULATE, ROW, TOPN, etc. are not working. How do I pull that value (eg. 3273) from the row and put it into a measure so that I can display it on a card? HELP!

[amitchandak · Accepted solution]

@Werbenmanjensen ,  A measure, Use Max if need

calculate(Sum(Table[Value for FOC/AOQ Testing]), Table[Totle for FOC/AOQ Testing] = "AQC Tested") )

[Werbenmanjensen]

It took me a second to get this, but it worked!! I ended with

" AQC FQC Values = CALCULATE(SUM('Batches Synthesized'[Values for FQC/AQC Testing]), 'Batches Synthesized'[Titles for FQC/AQC Testing]= "AQC Tested") "

Thank you!!