Forum Discussion

Werbenmanjensen's avatar
Werbenmanjensen
Frequent Visitor
3 years ago
Solved

Putting a Row Value into a Card Visual

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's avatar
    amitchandak
    3 years ago

    Werbenmanjensen ,  A measure, Use Max if need

     

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

2 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    3 years ago

    Werbenmanjensen ,  A measure, Use Max if need

     

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

    • Werbenmanjensen's avatar
      Werbenmanjensen
      Frequent Visitor
      3 years ago

      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!!