Show visual card from selected row

[Will90]

Hi,

I have a dropdown slicer on "Weeks" and the table below. When I select 41, how can I get the Card to show the sum of all "Time taken" greater than and equal to 2 hours? - How can I get it to show 2 on the card?

Week 42 will be 0

Week 43 will be 3

Thank you.

[Ashish_Mathur · Accepted solution]

Hi,

Try this measure

=CALCULATE(SUM(Data[Time Taken]),Data[Time Taken]>=2/24)

Hope this helps.