Vizualization : Card

[cocomy]

Hi All,

I would like to show calculated result of the last day I selected by slicer on the card.

Sales

Date           Sales

1 Apr 2018 20

2 Apr 2018 30

3 Apr 2018 10

.

.

15 Apr 2018 40

Slicer

1 Apr 2018 - 15 Apr 2018

Card

40

Currently card shows total of sales but I would like to show 40.

How can I do that? Appreciate your help.

All the best,

cocomy

[Zubair_Muhammad · Accepted solution]

Hi @cocomy

Try this mEASURE

Measure = 
CALCULATE ( SUM ( Sales[Sales] ), LASTDATE ( Sales[Date] ) )

[Zubair_Muhammad · Accepted solution]

Hi @cocomy

Try this mEASURE

Measure = 
CALCULATE ( SUM ( Sales[Sales] ), LASTDATE ( Sales[Date] ) )

[cocomy · Accepted solution]

Hi Zubair,

Thank you very much. It is what I was looking for.

All the best

cocomy