Display Slicer value dynamically on card

[kristydanda]

Hi

I have Phonelog table that have DateofRecord as a column

I use DateofRecord in Slicer.  what I want to get is when user choose As of Date in the last 20(or N number of days). I like to display 20 (or N number of days) in the card. see attached picture.

How to accomplish this?

thanks

[v-lili6-msft]

hi, @kristydanda

If "As of Date" is a field of calendar table?

If so, you could create a measure 

number of days be choosed = CALCULATE(COUNTA('calendar'[As of Date]))

then drag it into a card visual.

If not, you could create a calendar table, then create a relationship with As of Date, 

then create a measure like below:

number of days be choosed = CALCULATE(COUNTA('calendar'[Date]))

Then drag the field of date from calendar table into slicer and the measure into card visual.

Best Regards,

Lin

[kristydanda · Accepted solution]

thank you Lin, this works. thank you for your quick reply!