Forum Discussion
Latest Date from Multiple Rows
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 LiIf this post helps then please consider Accept it as the solution to help the other members find it more quickly.
Thanks for your continued support (and patience). You additionaly solution worked, and now trying to get the filtered quantity value showing in a cardbut it shows the unfiltered quantity. I therefore, thought I would be able to apply your measure to the card filter, but it doesnt allow me to use the dropdown options.
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.
Thanks, thats great and that also helped me with my calculated table question, and I created a calculated table replicating my invoice table, but only containing the most recent invoice rows. Then I can refer to the calculated table.
Will the calculated "Invoice Table" automatically update with any changes made on the "Invoice Output" table when the "Invoice Output" table is refreshed. I believe it does, but just checking.
Invoice Table = CALCULATETABLE('Invoice Output', FILTER ( ALL ( 'Invoice Output' ), [Latest Invoice Date] = 1 ) )Once again, thanks for your continued support.You are welcome😀.
Best Regards,
Yingjie Li