Search code examples
filterpowerbidaxaggregation

DAX formula to sum individual rows by a given date and show it in a Card

I am trying to sum the inventory units as of a given date (driven by a slicer) and put it in a Card.

Measure = CALCULATE ( SUM ( Inv[TY Inv] ), 'DailySales'[Like Date] )

I have this but seems to add all dates instead of one day

Thanks in advance

Solution

  • Try this

    Measure = CALCULATE ( SUM ( Inv[TY Inv] ), 'DailySales'[Like Date] = SELECTEDVALUE('DailySales'[Like Date]))