Forum Discussion

StuartSmith's avatar
StuartSmith
Icon for Power Participant rankPower Participant
6 years ago
Solved

Latest Date from Multiple Rows

I have a table visual similar to the below and need to filter the table, so it only shows the latest for each coumtry.     Unfiltered Table Country Date Qty UK 01/09/2020 10 UK 01/10...
Need Help
  • v-yingjl's avatar
    v-yingjl
    6 years ago

    Hi StuartSmith ,

    To make the card visual show the same total in the table visual, you can create another measure to calculate it and put it in the card visual:

    Sum of Qty = 
CALCULATE ( SUM ( 'Table'[Qty] ), FILTER ( ALL ( 'Table' ), [Control] = 1 ) )

    Check the modified sample file in the below, hopes to help you.

     

    Best Regards,
    Yingjie Li

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